What Is a Column on Excel

Q: How do I insert or delete a column with the keyboard?

Select the column header and press Ctrl + Shift + + (plus) to insert a new column to its left, or Ctrl + - (minus) to delete the selected column. Both shortcuts work on Windows and Mac.

A column in Excel is a vertical group of cells that runs from the top of the worksheet to the bottom, identified by a letter heading such as A, B, or C. Columns are one of the two building blocks of every spreadsheet (the other being rows), and they give your data a logical, sortable structure.

Understanding Columns in Excel

Excel is a powerful tool that allows you to manipulate, analyze, and visualize data with ease. The program is organized into a grid of cells that are arranged in rows and columns. Each of these cells can contain data or a formula, making it possible to perform complex calculations quickly and accurately. A column is a vertical arrangement of cells that extends from the top of the worksheet to the bottom.

Columns are labeled with letters along the top of the worksheet — A, B, C, and so on. After Z, the labels continue with two letters (AA, AB, AC…) and eventually three (AAA, AAB…). Rows, by contrast, run horizontally and are labeled with numbers. The intersection of a column and a row is a single cell, and its address combines the two — for example, cell C5 sits in column C, row 5.

How many columns does Excel have?

A single worksheet in modern Excel (2007 and later, including Microsoft 365 on both Windows and Mac) contains 16,384 columns. The first column is A and the very last is XFD. If you press Ctrl + Right Arrow (or Cmd + Right Arrow on a Mac) from cell A1 on an empty sheet, the selection jumps to column XFD, confirming the limit. Worksheets also hold 1,048,576 rows, for a grand total of more than 17 billion cells per sheet.

Creating a Column

To insert a column in Excel, follow these simple steps:

Step 1: Select a cell or column header

Click on a cell in the column to the right of where you want the new column to appear, or click the column letter to select the whole column. Excel always inserts the new column to the left of your selection.

Step 2: Open the Insert command

On the Home tab, in the Cells group, click the arrow next to Insert and choose Insert Sheet Columns. You can also right-click the selected column header and choose Insert from the menu.

Step 3: Continue adding data

Your new, blank column is now ready. Click on any cell within it and begin adding data or a formula.

A faster method on both Windows and Mac is to select a column header and press Ctrl + Shift + + (the plus key) to insert. To delete a column, select its header and press Ctrl + - (minus), or right-click the header and choose Delete. For a fuller walkthrough, see our guide on how to insert a column in Excel.

Selecting an Entire Column

To select an entire column, click its letter heading once — every cell in that column, top to bottom, is highlighted. If your cursor is already inside the column, press Ctrl + Space (this shortcut is the same on Windows and Mac) to select the whole column without reaching for the mouse.

To select several columns at once, click the first column letter and drag across the adjacent headers, or hold Ctrl (Cmd on Mac) and click non-adjacent headers to pick them individually. See how to select an entire column and how to select multiple columns for the full set of methods.

Adjusting Column Width

Once you’ve created a column, you may want to resize it so the contents are easy to read.

To adjust the width manually, hover over the right edge of the column header until the cursor becomes a double-headed arrow, then click and drag to the width you want. To make a column resize automatically to fit its longest entry, double-click that same edge, or select the column and choose Home → Format → AutoFit Column Width. The AutoFit shortcut works identically on Windows and Mac. Our dedicated guides cover adjusting column width and using AutoFit on a column in detail.

Hiding and Unhiding Columns

Hiding a column keeps its data and formulas intact while removing it from view — useful for tidying a report or concealing helper calculations. Right-click the column header and choose Hide, or select the column and press Ctrl + 0 (zero) on Windows.

To bring a hidden column back, select the columns on either side of it, right-click, and choose Unhide. See how to hide columns and how to unhide a column for step-by-step instructions, including how to recover a hidden column A.

Moving Columns

To move a column to a new position, select its header, then hover over the edge of the selection until the cursor turns into a four-headed move arrow. Hold Shift and drag the column to its new location — the green insertion line shows where it will land, and the surrounding columns shift to make room. Releasing without Shift overwrites the destination instead of inserting, so keep Shift held. The full process is covered in how to move a column in Excel.

Converting Column Letters to Numbers (R1C1 Style)

Because columns are normally labeled with letters, you may occasionally need a column’s number — for example, the COLUMN function returns 3 for column C, and a VLOOKUP needs a numeric column index. You can also switch Excel itself to number both columns and rows by turning on the R1C1 reference style: go to File → Options → Formulas (on Mac, Excel → Preferences → Calculation) and tick R1C1 reference style. With it enabled, cell C5 is written as R5C3, and the column headings show numbers instead of letters. For the math and lookup tables that convert between the two systems, see why Excel columns can be numbers and how to convert them.

Using Columns for Data Organization

Using columns is an essential feature of Excel that allows you to keep data organized quickly. Columns provide a logical structure for storing and manipulating data. For instance, a company’s financial or sales analysis typically involves spreadsheets with time-series data such as the revenues and expenses for a particular period. By putting these elements in columns, you can work around them and quickly analyze them against different time periods.

By detailing each column accordingly, you can relate to them as unique components of the business or data being worked on. Multiple worksheets within an Excel file can also be organized using rows and columns to keep everything neat and easy to navigate. The result of putting data in columns is that sorting, filtering, and using data presentations like PivotTables become effortless and more efficient.

When you build a structured table, it often helps to keep the headers visible as you scroll and to total a column of figures. You can pin the headings with freeze panes for the top row and first column, and quickly total a column with the techniques in how to add a sum column.

Working With Multiple Columns

Excel is capable of supporting multiple columns to satisfy various use cases of working with data. Depending on your purpose, you can add more than one column to an Excel sheet. Sometimes, you may need to add additional columns as part of your analysis when an original dataset lacks necessary data fields.

When adding a new column, you may want to consider whether the data you’re adding is essential to your analysis or can be left to the existing cells. To keep your analysis neat, keep data fields separate from each other. An efficient process for adding data fields involves keeping the data well-documented so you can quickly retrieve information as you work on different sheets. To insert several blank columns at once, select that many existing column headers before running the insert columns command — Excel adds one new column for each header you selected.

Troubleshooting Common Column Issues

Columns show numbers instead of letters. The R1C1 reference style is switched on. Turn it off under File → Options → Formulas (Mac: Excel → Preferences → Calculation) by unticking R1C1 reference style.
Column A seems to be missing. It’s almost certainly hidden. Select the small box where the row and column headers meet to select the whole sheet, then right-click any column header and choose Unhide.
You see ”########” in a column. The column is too narrow to display a number or date. Widen it by double-clicking the right edge of the header to AutoFit.
The Insert option is greyed out. The sheet may be protected, or the workbook already contains data in the last column (XFD). Clear or unprotect first, then insert.

Frequently Asked Questions

What is a column in Excel?

A column is a vertical line of cells running from the top of a worksheet to the bottom, identified by a letter heading (A, B, C, and so on). Columns let you store all the values for one data field — such as every customer’s name or every month’s revenue — in a single, easy-to-sort location.

How many columns are in an Excel worksheet?

A worksheet in Excel 2007 or later, including Microsoft 365 on Windows and Mac, has 16,384 columns. They run from column A through column XFD, which is the last column on the sheet.

How do I select an entire column quickly?

Click the column’s letter heading to select every cell in it, or — if your cursor is already inside the column — press Ctrl + Space. This shortcut works the same on Windows and Mac.

How do I insert or delete a column with the keyboard?

Select the column header and press Ctrl + Shift + + (plus) to insert a new column to its left, or Ctrl + - (minus) to delete the selected column. Both shortcuts work on Windows and Mac.

Why are my columns showing numbers instead of letters?

Excel has switched to the R1C1 reference style, which numbers both rows and columns. To restore letter headings, go to File → Options → Formulas (Mac: Excel → Preferences → Calculation) and clear the R1C1 reference style checkbox.

How do I make a column wide enough to fit its contents?

Double-click the right edge of the column header to AutoFit it to the longest entry, or select the column and choose Home → Format → AutoFit Column Width. If a cell shows ”########”, the column is simply too narrow and AutoFit will fix it.