Insert or delete rows, and columns

In Excel, you can easily insert or delete rows and columns to adjust the layout of your data. Here’s how to do it:

Insert Rows or Columns:

Insert a Row:

1. Select a Row:
   • Click the row number on the left side of the worksheet where you want to insert a new row. The new row will be inserted above the selected row.
2. Insert the Row:
   • Right-click the selected row and choose Insert.
   • Alternatively, go to the Home tab on the ribbon, in the Cells group, click Insert, and choose Insert Sheet Rows.

Insert Multiple Rows:

• To insert multiple rows, select the number of rows you want to add (e.g., select 3 rows if you want to insert 3 new rows), then follow the same steps as above.

Insert a Column:

1. Select a Column:
   • Click the letter at the top of the column where you want to insert a new column. The new column will be inserted to the left of the selected column.
2. Insert the Column:
   • Right-click the selected column and choose Insert.
   • Alternatively, go to the Home tab on the ribbon, in the Cells group, click Insert, and choose Insert Sheet Columns.

Insert Multiple Columns:

• To insert multiple columns, select the number of columns you want to add (e.g., select 3 columns if you want to insert 3 new ones), then follow the same steps.

Delete Rows or Columns:

Delete a Row:

1. Select the Row:
   • Click the row number on the left of the row you want to delete.
2. Delete the Row:
   • Right-click the selected row and choose Delete.
   • Alternatively, go to the Home tab, in the Cells group, click Delete, and choose Delete Sheet Rows.

Delete a Column:

1. Select the Column:
   • Click the letter at the top of the column you want to delete.
2. Delete the Column:
   • Right-click the selected column and choose Delete.
   • Alternatively, go to the Home tab, in the Cells group, click Delete, and choose Delete Sheet Columns.

Shortcuts for Inserting and Deleting Rows or Columns:

• Insert a Row: Select the row and press Ctrl + Shift + “+” (Windows) or Command + Shift + “+” (Mac).
• Insert a Column: Select the column and press Ctrl + Shift + “+” (Windows) or Command + Shift + “+” (Mac).
• Delete a Row: Select the row and press Ctrl + “-“ (Windows) or Command + “-“ (Mac).
• Delete a Column: Select the column and press Ctrl + “-“ (Windows) or Command + “-“ (Mac).

These steps make it easy to adjust the structure of your Excel worksheet by adding or removing rows and columns.