10 Excel Quick Tips
Part two of a -part series of blogs

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!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula (this blog)
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months

Posted by Andrew Gould on 02 December 2011 | no comments

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

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!

  1. Start creating your formula up to the point where you've entered the cell reference you want to add dollar signs to.
Creating the original formula

Here we want to put dollar signs in the H3 cell reference, so we have selected it.

  1. Make sure the text cursor is in contact with the cell reference, and then press the F4 key on the keyboard.
Dollar signs in formula

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.