Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 256
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get the lines in an Excell document to print? Robert-Harry New Users to Excel 13 January 14th 10 10:30 PM
How do I print in excell without alphanumeric columns on document. Terry Excel Worksheet Functions 1 May 24th 06 05:54 PM
Can I view an excell document without excell (not installed wit. Gordon Excel Discussion (Misc queries) 8 May 2nd 06 05:41 AM
how do i rotate a document or print small document on envelope crystal New Users to Excel 2 March 23rd 06 03:52 PM
Can I view an excell document without excell (not installed wit. Kevin Excel Discussion (Misc queries) 1 February 16th 05 08:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"