Keyboard shortcuts to add, delete rows and columns in Excel

Microsoft Excel is a powerful tool for organising and analysing data. Here are some tips on how to add and delete rows and columns in Excel with short keys.

Shortcut keys

Shortcut to add rows in Excel

To add a new row in Excel, you can use the following keyboard shortcut:

1. Press Ctrl + Shift + + on your keyboard to insert new rows.
2. Alternatively, right-click on the selected rows and select “Insert” to add new rows.

Deleting rows in Excel

To delete a row in Excel, you can use the following keyboard shortcut:

1. Select the row you want to delete by clicking on the row number.
2. Press Ctrl + - (minus sign) on your keyboard to delete the row.

Read more: Signing your documents in Word — Quick and easy guide

Adding columns in Excel

To add a new column in Excel, you can use the following keyboard shortcut:

1. Press Ctrl + Shift + + on your keyboard to insert new columns.
2. Alternatively, right-click on the selected columns and select “Insert” to add new columns.

Deleting columns in Excel

To delete a column in Excel, you can use the following keyboard shortcut:

1. Select the column you want to delete by clicking on the column letter.
2. Press Ctrl + - (minus sign) on your keyboard to delete the column.

Inserting line breaks in Excel

To insert a line break in a cell in Excel, you can use the following keyboard shortcut:

1. Press Alt + Enter on your keyboard to insert a line break.

Enabling filter button in a column

To enable the filter button in a column in Excel, you can use the following keyboard shortcut:

1. Select the column you want to filter by clicking on the column letter.
2. Press Ctrl + Shift + L on your keyboard to enable the filter button.