Otherwise, Excel will match the references in a ‘logical’ way to match every cell row or column index. Note that if you use the “$” character to lock any rows or columns, Excel will keep those references as is.

Then, type in your formula and press Ctrl+Enter to apply it to all selected cells. Tipsīegin by selecting the cells that you want to insert or modify formulas into. The headers and summary rows in Excel Tables work differently than regular cells.įill multiple cells with a formula or static value. Selecting headings and summary rows only work with Excel Tables. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet.Pressing Ctrl+Shift+Spacebar a second time selects the current region, its column header, and the summary cells (if applicable).Ctrl+Shift+Spacebar selects the current region.Then, press Ctrl + - to delete those rows. 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. You can also use this shortcut when a range, a column, or a row is selected.

a table), select the cell in the first column, and then press Ctrl + Shift + Right Arrow Key. To select all cells with a value in it from a range (i.e. Select any cell and press the F4 key after an action, like setting a background color or pasting a cell.Įxpand the selection to the last non-empty cell ShortcutĮxpands your current cell selection to the last non-empty cell. Repeats the last command or workbook action, where applicable.

Repeat the last command or action Shortcut Don’t let this intimidate you, because we’ve compiled a list of 10 most useful Excel shortcuts to help you cover the basics and be more productive. You might be thinking, ‘but there’s millions of features in Excel’. This gives them an edge to do everything far more rapidly, as there is a shortcut pretty much every action in Excel. Although the computer mouse is an essential tool in desktop navigation, Excel power users rarely use it to interact with their workbooks.

Excel page down shortcut