Contents:
Insert Column | Delete Column | Hide Column | Unhide row | Sizing Column
How do I insert a new column in excel? How do I delete a column in excel? How to delete multiple columns in Excel workbook? How to hide a column from being displayed in excel? How to unhide the hidden columns in excel? This post will guide you how to Insert/Delete/Hide/Unhide/Sizing columns in Microsoft Excel.
Insert Column
If you wish to insert a new column in current workbook, just following below steps:
#1 Select one column or a cell that you want to insert the new column and the new column will be inserted on the left side of the selected column or cell. For example: select column B or B1 cell.
#2 Right-click and then click “Insert…”
#3 A “Insert” window will appear. Then click “Entire column” radio button.
#4 Let’ see the result.
Delete Column
If you wish to delete one column or multiple columns in current workbook, just following below steps:
#1 Select a cell or a column that you want to delete. For example: select column 2 or B2 cell.
#2 Right-click and then click “Delete…”
#3 A “Delete” window will appear. Then click “Entire row” radio button. Click “OK” button.
#4 Let’ see the result.
Note: if you want to delete multiple columns, you just need to select those columns via clicking column number then right-click on it. Next, click “Delete”. All columns you selected will be deleted immediately.
Hide Column
The below steps will explain that how to hide a column in excel.
#1 Select column that you wish to hide via clicking column number.
#2 Right-click on column B, then click “Hide”
#3 Let’s see the result, column B should be hidden.
Unhide row
If you wish to unhide the hidden column, please refer to the below steps:
#1 Select the columns that contain the hidden column. For example, column B was hidden, now we need to select Column A and Column C.
#2 Right click and select “Unhide”
#3 The hidden column should be unhidden, let’s see the result.
Sizing Column
Sometimes, we wish to change the width of a column in excel, the below steps will guide you how to change the column width.
#1 Select column that you want to change width via clicking column number.
#2 Right-click and then click “Column Width…”
#3 A “Column width” window will appear.
#4 Input new value for column width, such as: 20, then click “OK” button.
#5 Let’s see the result. column 3 should be the new column width.
