How to print line numbers but not column headers?

[Guest]

In Excel is it possible to print the Row Headings but not the Column
Headings. I want to print the line numbers down the side but do not want the
column headings. I do not see a way to separate them.

 

[Guest]

insert an extra column on the left and fill it with the row numbers
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Earl Kiosterud]

I think you mean row numbers. You can put them in a column yourself. Select the column
following where you'd like to have them (click in the column header). Insert a column
(Edit - Insert, or Ctrl +_. Put the first line number in the first cell, then drag the fill
handle (lower right corner of the cell) down holding the Ctrl key.

 

[Guest]

Thank you. Your suggestion worked great. Bill

 

[Carole]

Adding a column on the left doesn't help if you want to sort your data. The
"row headings" you create will jumble out of order. If you're working with a
large spread sheet it's a pain to have to select everything EXCEPT that new
column when sorting. Still looking for an easier way!

 

[Richard Schollar]

Hello Carole

Rather than fill the column with hardcoded numbers, fill it with the ROW()
formula executed like this:

=ROW()

and copied all the way down. It will always reflect the row number of the
cell in which it appears so you are free to sort to your heart's desire
(assuming you have Automatic Calculation enabled).

Richard

 

[Carole]

Thank you sooo much. That worked great!

Adding a column on the left doesn't help if you want to sort your data. The
"row headings" you create will jumble out of order. If you're working with a
large spread sheet it's a pain to have to select everything EXCEPT that new
column when sorting. Still looking for an easier way!

 

[campy]

In Excel is it possible to print the Row Headings but not the Column
Headings. I want to print the line numbers down the side but do not want the
column headings. I do not see a way to separate them.

 

[HAMEL]

In Excel is it possible to print the Row Headings but not the Column
Headings. I want to print the line numbers down the side but do not want the
column headings. I do not see a way to separate them.