Row numbers

[Guest]

I want to label and print row numbers for each row, however, I do not wish to
print column headings...can I disable the printing of the column headings?

Is there possibly a function to run in a cell to provide it a number or
something else?

 

[RagDyer]

You can only disable printing column *and* row headings.

<File> <PageSetup> <Sheet> tab,
Make sure "column & row headings" is *unchecked*.

Then, you can number your first column to mirror the row numbers, and that
will give the impression of displaying and printing the row headers.

You could enter this formula in the first column:

=ROW()

Which will display the row number, even if rows might be subsequently
deleted.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Earl Kiosterud]

Scott,

If you mean the "Row and column headings" option in Page setup, no. But you
can turn that off, and put in your own row numbers. Put the first one in
column A, then copy down with the fill handle holding Ctrl. Or put =ROW(),
or =ROW()-1, etc., and copy that down.