Column

Updated: 05/01/2023 by Computer Hope

A column may refer to any of the following:

1. A column is a vertical series of cells in a chart, table, or spreadsheet. Below is an example of a Microsoft Excel spreadsheet with column headers (column letter) A, B, C, D, E, F, G, and H. As you can see in the image, the last column H is highlighted in red, and the selected cell (D8), is in the D column.

Overview of a Microsoft Excel spreadsheet.

How are columns and rows labeled?

All spreadsheet programs, including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters starting with the letter A and then incrementing by a letter after the final letter Z. For example, after the letter Z, the next column is AA, AB, AC, ..., AZ and then incrementing to BA, BB, BC, etc. to the last column XFD.

When working with a cell, you combine the column with the row. For example, the first cell is in column A and on row 1, so the cell is labeled as A1.

How can I freeze or make a column that does not move?

To keep column 'A' or a set of columns frozen, so they don't move as you scroll, use the freeze pane option.

How to highlight a column using the keyboard

To highlight a column in Microsoft Excel using your keyboard, move to a cell in the column you want to highlight. Then, press the keyboard shortcut Ctrl+spacebar.

How are columns created in an HTML table?

A column is created in an HTML (hypertext markup language) table using the <td> tag contained in a <tr> tag.

2. With a document, a column is a container that holds text. Having a document with multiple columns allows shorter lines of text and is a more presentable method of displaying a list with dozens or hundreds of items.

3. With a database, the columns in the table are the fields.

4. When describing a newspaper or magazine, a column or periodical is a regularly featured opinion done by a columnist. For example, a column related to computers could cover computer-related questions, new technology, and other computer-related information the columnist enjoys.

Card column, Cell, Chart, Column break, Grid line, Row, Rule, Spreadsheet, Spreadsheet terms, Table