Row numbers
 

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?

-----------------
Scott

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!
==============================================

"Scotts" wrote in message
...
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?

-----------------
Scott

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Scotts" wrote in message
...
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?

-----------------
Scott