totn Excel

MS Excel: Columns

In Microsoft Excel, a column runs vertically in the grid layout of a worksheet. Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such 1, 2, 3.

Microsoft Excel

Each column in the worksheet has its own column number which is used as part of a cell reference such as A1, A2, or M16. You can select an entire column by clicking on the column heading (ie: the letters running along the top of the grid layout). In the example above, we have selected column B.

There are many things that you can do with columns in Excel such as inserting, deleting, hiding, unhiding, and resizing columns. Here is a list of topics that explain how to use columns in Excel.

Insert / Delete

Hide / Unhide

Sizing