EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you change the column heading names in Excel (ex.top headings A B
C change to first second third)?
 
Bobby

You cannot change these.

Best workaround is to enter your header titles in row 1.

Then select A2 and Window>Freeze Panes to lock row 1 in view as you scroll.

OR select B2 to Freeze row 1 and column A

Then...Tools>Options>View. Uncheck "row and column headers".

Gord Dibben Excel MVP
 
Hi Bobby,
and if you want to see numbers below the first row
in cell A2: =ROW()-1
and use the fill handle to fill down. Of course what is seen
as a number on the printed page will not be the real row number.

You were told about Freeze for displaying the top row,
for printing you use File, Page Setup, Sheet,
Rows to repeat at top: $1:$1

More information in on
http://www.mvps.org/dmcritchie/excel/freeze.htm
 
Back
Top