Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula (this blog)
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Posted by Andrew Gould on 02 December 2011 | no comments
Excel Quick Tip #2 - Putting Dollar Signs in a Formula
In Excel, you put dollar signs in a cell reference to keep it fixed when you copy a formula around. It's laborious having to type dollar signs into a cell reference, but fortunately there's a keyboard shortcut you can use instead!
- Start creating your formula up to the point where you've entered the cell reference you want to add dollar signs to.
Here we want to put dollar signs in the H3 cell reference, so we have selected it.
- Make sure the text cursor is in contact with the cell reference, and then press the F4 key on the keyboard.
Two dollar signs appear in the selected cell reference.
You can continue pressing F4 to cycle through the various combinations of dollar signs - for the example above these would be H3, $H$3, H$3 and $H3.
You can see this technique in action in this short video tutorial.