How to Add, Remove, and Hide Rows or Columns in Excel

3] Using Keyboard Shortcuts

This method is the fastest and most practical way to add rows or columns in Excel, especially if you are used to using the keyboard. Here are the steps:

1. Select any cell in the row or column adjacent to where you want to add a new row or column, just like the previous way.
2. Press the following keyboard shortcut according to the operating system that you are using:
   • For Windows, press “Ctrl + +” (plus-sign).
   • For Mac, press “Command + +” (plus-sign).
3. This will open the same “Insert” dialog box as the previous way.
4. Select the “Entire Row” option to add a new row, or the “Entire Column” option to add a new column. It will insert a new row or column according to the position of your previously selected cell.
5. Click OK to apply the changes.
6. Repeat these steps to add more than one row or column.

How to Delete Rows or Columns in Excel

There are several ways you can use to delete rows or columns in Excel. Here are some of them:

1] Using the Delete Menu

This method is the most common and easy way to delete rows or columns in Excel. Here are the steps:

1. Select any cell in the row or column you want to delete. For example, if you want to delete row 5, select any cell in row 5. If you want to delete column C, select any cell in column C.
2. Click the “Home” tab on the “Ribbon”, just like the previous method.
3. Click the “Delete” button in the “Cells” group. This will open a drop-down menu with several options.
4. Select the “Delete Sheet Rows” option to delete the selected rows, or the “Delete Sheet Columns” option to delete the selected columns. It will delete rows or columns according to the position of your previously selected cells.
5. Repeat these steps to delete more than one row or column.

2] Using Right Click

This method is an alternative way that is also quite easy to delete rows or columns in Excel. Here are the steps:

1. Select any cell in the row or column you want to delete, just like the previous way.
2. Right-click on the selected cell. This will open a context menu with several options.
3. Select the “Delete…” option. This will open a “Delete” dialog box with several options.
4. Select the Entire Rows option to delete the selected rows, or the Entire Columns option to delete the selected columns. It will delete rows or columns according to the position of your previously selected cells.
5. Click OK to apply the changes.
6. Repeat these steps to delete more than one row or column.

3] Using Keyboard Shortcuts

This method is the fastest and most practical way to delete rows or columns in Excel, especially if you are used to using the keyboard. Here are the steps:

1. Select any cell in the row or column you want to delete, just like the previous way.
2. Press the following keyboard shortcut according to the operating system that you are using:
   • For Windows, press “Ctrl + -” (minus sign).
   • For Mac, press “Command + -” (minus sign).
3. This will open the same “Delete” dialog box as the previous way.
4. Select the “Entire Row” option to delete the selected rows, or the “Entire Column” option to delete the selected columns. It will delete rows or columns according to the position of your previously selected cells.
5. Click OK to apply the changes.
6. Repeat these steps to delete more than one row or column.