In excel, there are multiple ways to do the same thing. For example, here are 2 ways to add Column to a spreadsheet - Excel for Mac version.
- Right click the column header and then click insert in the drop down box - this will add a column to the left of the column you selected.
- Click a cell and then right click and select insert. You will see a pop up menu like the one in the image below. Select entire column and select the ok button to add a column to the left of your selected cell.
- Click a cell and click insert in the top file menu and then click columns in the drop down box - this will also add a column to the left of the column you selected.
To delete the column, you will perform the following steps.
- Rick click in the column you want to delete and select delete in the drop down box. You will see the menu shown above. Choose entire column and select the ok button.
- Similarly, you can also select a cell in the column you want to delete, then click edit in the top menu and the delete button. You will see the same pop-up menu as above. Select entire column and then select ok.
