How to do the $ thing in Excel Tutorial Video

Excel-tip-F4A quick simple tip, mostly for Mac users, with Excel and Google Sheets:
The shortcut for putting the $ symbol in your equations! (check out the tutorial video here)

Or for a more technical description; cycling through all 4 types of cell references (absolute, mixed reference (2x) and relative).

I’ve seen too many Mac (and a few Windows) users suffer by not knowing this shortcut, so here it is.

If you didn’t know about this shortcut, let me know over on the Facebook page, and if enough of you do then we can work out how much collective time we’ve saved using the tool below:

Share:

Leave a Reply

Your email address will not be published.

Table of Contents

Social Media:

Most Popular:

Related Posts

Datasaurus

Join the mailing list

Sign up to The Rawr newsletter to stay up to date on new content from the site and YouTube channel. 

Datasaurus

Join the mailing list

Sign up to The Rawr newsletter to stay up to date on new content from the site and YouTube channel.