![]() ![]() This is some advanced stuff so I'll break it down: This is fantastic because editing one formula is much easier than changing a column's worth. In the context of subtracting entire columns: ArrayFormula means we can use one formula to output in every row instead of having a formula in every row. It allows formulas and operators that normally don't accept arrays (ranges of data) to handle them. Then use the keyboard shortcut Ctrl+D (for Windows) or ⌘+D (for Mac) to fill the formula into the rest of the selection: Subtracting Entire Columns Using the ArrayFormula FunctionĪrrayFormula is an advanced Google Sheets function. You can make a selection that includes the formula you want to autofill in the top cell and empty cells below it. 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. |