Question:In Microsoft Excel 2016, how do I delete a column in a spreadsheet?
Answer: Select a cell in the column that you wish to delete. In this example, we've selected cell B3 because we want to delete colulmn B.
![Microsoft Excel](http://www.techonthenet.com/excel/columns/images/delete2016_001.png)
Right-click and select "Delete" from the popup menu.
![Microsoft Excel](http://www.techonthenet.com/excel/columns/images/delete2016_002.png)
When the Delete window appears, select the "Entire column" option and click on the OK button.
![Microsoft Excel](http://www.techonthenet.com/excel/columns/images/delete2016_003.png)
The column should now be deleted in the spreadsheet. In this example, column B was deleted and the data in the columns to the right were shifted over to the left.
![Microsoft Excel](http://www.techonthenet.com/excel/columns/images/delete2016_004.png)
No comments:
Post a Comment