Excel with Examples

How to insert a column/cells in Excel?

*Click images to enlarge

Hi, everybody! I hope you’re all well. This post is a part of the frequently asked question for beginner in Excel and here is brief introduction to some basics knowledge about Microsoft Excel Application
We gonna see together how to adding columns in Excel or multiple columns including cells inside a table in Excel.

Columns in Excel

The column header

A column in Microsoft Excel is a vertical block of cells in a worksheet. One or more columns can be selected to perform an action, or to enter data.

To select a column, click on the column header. The column header is the letter at the top of the column. For example, to select column C, click on the letter C.
The column header

To select multiple columns, click on the first column header, then hold down the shift key and click on the last column header. All the column headers between the first and last column will be selected.

Columns can also be selected by clicking on a cell in the column and then using the keyboard shortcut, Ctrl+Space. This will select the entire column that the cell is in.

Microsoft Excel Basics

Once a column is selected, you can perform actions on it, such as resizing, hiding, and deleting.

How to change the width of a column in Excel (Resizing Column)?

To resize a column, hover your mouse over the right edge of the column header. The mouse cursor will change to a resize icon. Click and drag the column to the desired width.

Hide / Unhide  columns in Excel

To hide a column, right-click on the column header and select Hide. The column will be hidden from view.

To unhide a column, right-click on any column header and select Unhide. This will bring up a dialog box listing all the hidden columns. Select the column you want to unhide and click OK.
hide-unhide-column-excel

Delete columns in Excel

To delete a column, right-click on the column header and select Delete. The column will be deleted and the cells shifted to the left.

Add columns in Excel

Adding columns in Excel is a quick and easy way to organize your data.

To add a column, simply click on the column header where you want the new column to appear and then click the “Insert” button. This will insert a new column to the left of the selected column.
add-column-excel

If you have a lot of data, you may want to consider using the “Insert” function to insert multiple columns at once. To do this, select the number of columns you want to insert from the “Insert” drop-down menu and then click the “OK” button. Excel will insert the specified number of columns to the left of the selected column.
add-multiple-column-excel

Cells in Excel

locking a cell in excel

Leave a Comment