Heading and numbering lines

  • Thread starter Thread starter Luv2resa0008
  • Start date Start date
L

Luv2resa0008

How do I change the heading from A B C to something else,
like Name, space number etc.

Also, Excel shows the lines number from 1 to 25, how do I
get it to print with the numbers showing. Thanks
 
Hi!

You can't change from ABC other than to 1, 2 3

Use:
Tools > Options > General
Check "R1C1 Reference Style"
OK

Alternatively you can insert headings into Row 1 and then hide the
column an row numbers using:

Tools > Options > View
Remove check from "Row and Column headers"

Once done. You can select A2 and use:

Windows > Freeze Panes

If you do the same for Rows select B2 before you use Freeze panes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top