Windows
Inserting Rows:
Select Row: Click on the row number where you want to insert a new row. This selects the entire row.
Insert Button: Locate the "Insert" button on the Home tab in the Cells group. It looks like a small arrow pointing downwards next to a line. Click on the arrow.
Choose "Insert Sheet Rows": In the dropdown menu, select "Insert Sheet Rows." This will insert a new row above the selected row.
Inserting Columns:
Select Column: Click on the column letter where you want to insert a new column. This selects the entire column.
Insert Button: Again, find the "Insert" button on the Home tab in the Cells group, but this time, click on the arrow and choose "Insert Sheet Columns" from the dropdown menu. This will insert a new column to the left of the selected column.
Deleting Rows:
Select Row: Click on the row number that corresponds to the row you want to delete. This selects the entire row.
Delete Button: On the Home tab, in the Cells group, find the "Delete" button, which also looks like a small arrow pointing downwards next to a line. Click on the arrow.
Choose "Delete Sheet Rows": In the dropdown menu, select "Delete Sheet Rows." This will delete the selected row, shifting the rows below it upwards.
Deleting Columns:
Select Column: Click on the column letter that corresponds to the column you want to delete. This selects the entire column.
Delete Button: Once again, find the "Delete" button on the Home tab, in the Cells group, and click on the arrow.
Choose "Delete Sheet Columns": In the dropdown menu, select "Delete Sheet Columns." This will delete the selected column, shifting the columns to the right of it to the left.