How do I print row numbers in an excell document?

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top