WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
Wise Owl Training
See 479 reviews for our classroom and online training
If you found this blog useful and youâ€™d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

10 Excel Quick Tips
Part two of a ten-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!

Posted by Andrew Gould on 02 December 2011

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.

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.

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, or see a full range of blogs, videos and exercises covering training in Microsoft Excel.