ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I print row numbers in an excell document? (https://www.excelbanter.com/excel-worksheet-functions/166845-how-do-i-print-row-numbers-excell-document.html)

Docjon

How do I print row numbers in an excell document?
 
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.

ilia

How do I print row numbers in an excell document?
 
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.


On Nov 20, 3:09 pm, Docjon wrote:
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.



Docjon

How do I print row numbers in an excell document?
 

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?

Peo Sjoblom

How do I print row numbers in an excell document?
 
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


"Docjon" wrote in message
...

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?





All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com