![]() ![]() Instead of double clicking the fill handle like above, you can click and drag it down as far as you'd like: When you have a formula in a cell, double clicking on the fill handle will copy the formula into the cells below whilever the data in the column to the left continues: It's the little blue square in the bottom right corner of the selection: When you select a cell or range the selection will have what's known as a 'fill handle'. When this happens you can type Ctrl+Enter or click on the tick to autofill the formula to the bottom of the column: When you type in a formula next to a column of adjacent numbers, Google Sheets automatically assumes you want to apply the new formula to the rest of the column. Google Sheets autofill is an amazing tool that allows you to quickly add formulas where you need them. Subtracting Entire Columns Using Autofill This saves time highlighting a large range and will automatically include additional entries in the 'Sales' and 'Costs' columns. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |