Absolute Cell References Shortcut

Ever use absolute cell references? If you're like me, you find it a pain to go in and type the little dollar signs everywhere. Next time - try this handy trick:

Click in the formula so that your cursor is in the cell reference that you'd like to make absolute. Now press F4. Excel automatically puts in the dollar signs for you. Cool, eh?

2 comments:

  1. Awesome. Thanks so much, I've been looking everywhere for this!

    ReplyDelete