Displaying the column number

From Apache OpenOffice Wiki
Revision as of 06:45, 28 May 2012 by Betsy ID (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

In spreadsheets, columns are referred to with letters. You can refer to columns as numbers by using a formula.

To display the column numbers, do the following steps:
  1. Select a cell.
  2. On the Formula Input Line, enter =column(cell_reference) and press Enter. For example, to display the column number of cell D7, enter =column(D7). If you leave the cell_reference empty, the column number of the current-selected cell is displayed.S column number formula.jpg
Personal tools