Shortcults

 

Navigate within a table

Maintain Ctrl pressed and use the arrow keys to go to the last non empty cell in the desired direction.

In this example, first go to the Values cell, then will pressing Ctrl, press down, right, up and left.

 

 

Select a range

Maintain Shift pressed and use the arrow keys to select the range.

In this example, starting from the Values cell, maintain the Shift key and press down, down, right, right, right.

 

 

Select a table

Maintain both the Ctrl and the Shift keys pressed and use the arrow keys to select a table.

In this example, starting from the Values cell, maintain both the Shift and the Ctrl keys and press down, right.

 

 

Insert a row or a column

Select a column (row), then press Ctrl, Shift and +, a column (row) will be inserted on its left (above).

Delete a row or a column

Select a column (row), then press Ctrl and -.

Lock a cell, a row or a column

 

When copying and pasting formulas, you may want to lock cells that refer to constants that apply to all subsequent cells.

Excel allows you to do that using the $ sign:

  • Lock the cell: $ sign before and after the letter of the cell ($A$1)

  • Lock the row$ sign after the letter of the cell (A$1)

  • Lock the column$ sign before the letter of the cell ($A1)

 

By pressing the F4 key in your keyboard when selecting the reference to lock, you can add the $ signs automatically:

  • Press once: lock the cell

  • Press twice: lock the row

  • Press three times: lock the column

 

 

Lock the cell

Lock the row

Lock the column

Switch between spreadsheets

 

To move quickly from the current spreadsheet to the previous or the next one, hold down Ctrl and Press either Page Up (for next) or Page Down (for previous).

Financial Modeling Academy

  • LinkedIn App Icon
  • Wix Facebook page
  • Wix Twitter page