Learn Excel How to do the $ thing in Excel Tutorial Video

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:

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Follow

Tableau PublicYouTubeTwitterFacebookLinkedInInstagramEmail Newsletter

Latest Articles

Groceries made easy using Google Sheets

Have you ever wanted to help out more around the house, but not have it take up a lot...

Time Saver Tool v2.0

Have you ever discovered a way to speed up a process but cannot convince others to do it? Felt like you don't...

SG Tableau User Group Oct 2020

The SG Tableau User Group just wrapped up it's October virtual livestream event, which you can now watch on YouTube here. It...

Find insights beyond the summary stats (w/ data viz)

In this video we will see how summary stats can be misleading and the importance of data viz to easily dig deeper into the numbers beneath them.

Data Studio Community Livestream | Jun 2020

Welcome to the first Data Studio Community Livestream - you'll see 4 speakers covering a wide variety of topics, which should help any and...