This gives them an edge to do everything far more rapidly, as there is a shortcut pretty much every action in Excel.

You might be thinking, but theres millions of features in Excel.

Dont let this intimidate you, because weve compiled a list of 10 most useful Excel shortcuts to help you cover the basics and be more productive.

For example, if you want to delete rows after 50 th, select row 51, and the press Ctrl Shift Down Arrow to select these cells.

The headers and summary rows in Excel Tables work differently than regular cells.

Then, type in your formula and press CtrlEnter to apply it to all selected cells.

Note that if you use the character to lock any rows or columns, Excel will keep those references as is.

Otherwise, Excel will match the references in a logical way to match every cell row or column index.

Shortcut For Data Filter Excel Mac Version Of

This shortcut is not available for the Mac version of Excel 2016.

Double click any name or reference on this list to select that range.

This can be useful to locate objects, formulas, validations, or other workbook elements.

Using the shortcut will move the active selection to the last cell in the direction of the Arrow Key used.

Please note that Excel will actually look for an empty cell and the navigation can stop at an empty cell, instead of the end point.