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 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.
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.
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.
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.
Cells in Excel
locking a cell in excel