Excel Columns

Contents:
Insert ColumnDelete ColumnHide ColumnUnhide rowSizing 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.

excel column select cell

#2 Right-click and then click “Insert…

excel column right-click

#3  A “Insert” window will appear. Then click “Entire column” radio button.

excel column entire column

#4 Let’ see the result.

excel column insert column

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.

x
How to Replace # Errors with Zero or Any Specific Value in Excel

#2 Right-click and then click “Delete…

excel column delete column

#3  A “Delete” window will appear. Then click “Entire row” radio button. Click “OK” button.

excel column delete entire column

#4 Let’ see the result.

excel column entire column 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.

excel column delete multiple column

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.

column hide selected

#2  Right-click on column B, then click “Hide

column hide right click

#3 Let’s see the result, column B should be hidden.

column hide result

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.

column unhide select

#2 Right click and select “Unhide

column unhide right click

#3 The hidden column should be unhidden, let’s see the result.

column unhide reslut

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…

column sizing right click

#3  A “Column width” window will appear.

column sizing width window

#4  Input new value for column width, such as: 20, then click “OK” button.

column sizing width set value

#5  Let’s see the result. column 3 should be the new column width.

column sizing result

Related Posts

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...

Combine Duplicate Rows and Sum the Values
combine duplicate rows7

This post will teach you how to combine duplicate rows and sum the corresponding values or calculate numbers in specific column in excel. And how to merge duplicate rows and then sum the values with VBA macro in Excel. How ...

Sidebar