Excel Level-Up: Day 4

Rows and Columns

In a lot of time, we have to play around with rows/columns, for example, insert new columns, hide rows or delete rows.

Today, you will learn how to do all of the above without touching your mouse.

Level 1: Selection

To select a row, press [Shift] + [Spacebar]

To select a column, press [Control] + [Spacebar]

Level 2: Insert

To insert a new row, select a row (refer to Selection), then press [Control] + [Shift] + [+]. It will add a new row above the selected row.

To insert a new column, select a column (refer to Selection), then press [Control] + [Shift] + [+]. It will add a new column to the left of the selected column.

Level 3:

To delete a row or column, select the row/column (refer to Selection), then press [Right Click Button] then [D].

Level 4:

To hide a row or column, select the row/column (refer to Selection), then press [Right Click Button] then [H].

Go back to previous awesome trick: Excel Level-Up: Day 3

Proceed to next awesome trick: Excel Level-Up: Day 5