Columns are Fields in Excel Spreadsheet. Excel Spreadsheet is container in the Workbook, it is in Tabular Format with Rows (Horizontal records) and Columns (Vertical fields). Each Column in a sheet represented with a unique Column Name, starts with Column name A.
Many Excel users raises these common question a about Excel Columns. How many columns in Excel Worksheet? Is there any limitation with Columns in Excel?
There are 16,384 Columns in the latest version of Excel Application (from Office 2007 and higher).
The maximum width of an Excel Column can set to 255 Characters.
MS Office Version
Usage & Properties
Here are most common uses of Excel Columns in our daily Excel tasks. We can do the following tasks and change the values of below Column properties if required.
We can increase and decrease the Column width based on our requirement
We can change the Interior Color if the Entire Column
We can select different font to a Column and format the font size, font name, font color, etc.
We can hide or unhide the Columns if required
We can Group Specific number of Columns in Excel to Expand and Collapse.
We can Clear Entire Column (range of Columns) at a time
We can Insert columns before or after a specif column
We can delete any specific column if required
Excel provided verity of built-in functions to deal with Columns. Here are the most commonly used Column Functions and Formulas.
Returns the Column number of the Given Address. Example: Row(D25) returns 4
Returns the Column number of the Cell.
Column()-1, return the previous Column of the Cell where the function is inserted. For example, if you insert this formula at J5, it returns 9.
Column()+1, return the next Column of the Cell where the function is inserted. For example, if you insert this formula at J5, it returns 11.
Returns the Column Numbers
Returns the Number of Column in a given Range. For example, =COLUMNS(A1:J2) returns 10.
Select the Entire first Column. For example, Sum(Column(5:5)) returns total of Column 5 values.
We can use $ symbol to make a Column reference absolute. For example $D5