Excel shortcuts

The Dollar Sign Shortcut in Excel You Didn't Know

If you're like most people, you probably use the dollar sign shortcut in Excel all the time without even realizing it. This helpful little tool can save you a ton of time when working with large spreadsheets. Here's how it works:

When you enter a cell reference in Excel, you can use the dollar sign to indicate that the reference is absolute. This means that no matter where you copy or move the formula, the cell reference will remain the same. For example, if you have a formula in cell A1 that references cell B1, you can make the reference absolute by adding a dollar sign before the column and row reference, like this: $B$1.

You can also use the dollar sign shortcut to make an entire column or row reference absolute. For example, if you want to reference the entire column B in your formula, you would use this: $B:$B. Or, if you want to reference the entire row 1, you would use this: 1:$1.

This may not seem like a big deal, but if you've ever tried to copy a formula down a column or across a row, you know that it can be a real pain if the cell references change. The dollar sign shortcut ensures that they don't.

So the next time you're working with a large spreadsheet, save yourself some time and use the dollar sign shortcut to make your life a little easier.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.