Displaying the column number

From Apache OpenOffice Wiki
Revision as of 15:42, 23 September 2013 by Adailton (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