Freeze row 1 by selecting A2 and WindowFreeze Panes.

Insert a column left of your data and in A2 enter =ROW()-1

Drag down as far as you wish.

ToolsOptionsView. Uncheck "Row and column headers"

I think you have to have a printer installed.

Excel bases its settings on the default printer.


Gord Dibben MS Excel MVP

On Sat, 23 Aug 2008 08:58:00 -0700, Canopus
wrote:

I do not have a printer installed, nor want to nor will ever have. I use
Excel as a database then send my creation via email. I would like my title
row to not be numbered at all (or maybe "A") So that the row numbers
accurately reflecr the number of entries - one loses track when getting to
say, row #87, and one forgets to subtract 1.