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.
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
- Insert a new column in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Delete a column in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
Hide / Unhide
- Hide a column in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Unhide a column in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Unhide column A in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
- Unhide all columns to the right in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
Sizing
Advertisements