Abstract
Transcript
In this video, we’ll look at shortcuts for working with formulas.
This means we have to lock both the column and row references to double-check they don’t change.
Use the same shortcut again to turn off formulas.
Whenever you better enter the same formula in multiple cells, you have several options.
you might double-grab the fill handle after you’ve entered the first formula.
you’ve got the option to enter the first formula and the use Control D to fill down.
you’ve got the option to select all cells and use Control Enter instead of just Enter.
To get rid of the formulas and leave only the result.
Copy the formulas, then use Paste Special > Values to overwrite.
Then you’re free to remove the formulas and data you don’t need.
you might also sometimes avoid formulas altogether by using Paste Special with a math operation.
you’re able to evaluate parts of the formula using F9.
This is an extremely useful tool to understand and troubleshoot more complex formulas.
you might use the function screen tip window to navigate and more precisely select arguments.
Use the same shortcut again to collapse.
To enter any array formula, use Control + Shift + Enter.
When you do this correctly, you’ll see curly braces on either side of the formula.
verify you use Control + Shift + Enter again when you edit the formula.
If you want to calculate only the active sheet, just add shift.
To force calculation of all open worksheets, use control + Alt + F9.
