shortcut for adding $ to excel equation on mac keyboard

Shortcut For Adding $ To Excel Equation On Keyboard Free Basic Skills

Here are eight useful keyboard shortcuts to speed up your work in Excel.

Bonus: Hold down Shift and the updown arrows to select multiple rows.

Bonus: Hold down Shift and the leftright arrows to select multiple columns.

If you dont want certain sensitive data to be visible, you can hide them (hidden rows and columns do not print).

If you use AutoFill often, youre probably used to double-clicking on the AutoFill handle to fill down a whole column of data, but you might wonder if you could do this more quickly by using a keyboard shortcut.

There isnt a specific keyboard shortcut for AutoFilling in this way, but there are some alternatives that could be useful.

Its a form of AutoFill that tries to intelligently figure out what kind of data you are trying to fill and automatically provide the values you need.

Its important to note that Flash Fill does not work with formulas; it will only work with ordinary values.

You can Flash Fill a whole column of data by simply pressing the shortcut keys.

Shortcut For Adding $ To Excel Equation On Keyboard Free Basic Skills

Flash Fill is explained in depth in the free Basic Skills E-book.

Nothing will happen if you press with only a single cell selected.

For this to work you need to first select all of the cells that you need to fill down to, which usually takes longer than using the AutoFill handle.

This means that you can use Excels Repeat feature to AutoFill as many times as you need after you have done the first AutoFill manually.

The shortcut key for the Repeat command is, but you can also add this command to your Ribbon or Quick Access Toolbar.

Customizing the Ribbon and Quick Access toolbar is covered in our Essential Skills Books and E-books.

This article explains why this e-book format is optimal for learning and includes screen grabs from the Kindle PC reader application.

Shortcut For Adding $ To Excel Equation On Mac Keyboard