How do I print row numbers in an excell document?

D

Docjon

I have print grid lines and row and column headings selected but I still
can't see the lines or numbers. I was able to print the Coliunm headings but
not the numbers.
 
I

ilia

Insert a new column all the way to the left, and use =ROW() function.
Then set the column to repeat in the left.

The way you're doing it should be working, however.
 
D

Docjon

I added a new first colum and put the =ROW() instruction in and it works for
only that single line or row Do I have to cut and paste the=ROW() commaND
FOR ALL 400 of my line items?
 
P

Peo Sjoblom

Put that formula in A1, select the A1:A400 and press Ctrl + d

replace a1 with whatever cell you put the formula in


--


Regards,


Peo Sjoblom
 
Top