Web Images Videos Maps News Groups Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
printing row numbers in Excel 97
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  6 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
niteowl  
View profile  
 More options Jul 24 2004, 10:52 am
Newsgroups: microsoft.public.excel.newusers
From: niteowl <nite...@NOniteowlproductionsSPAM.com>
Date: Sat, 24 Jul 2004 10:52:58 -0400
Local: Sat, Jul 24 2004 10:52 am
Subject: printing row numbers in Excel 97
Hi again,

along with the gridline challenge, I can't seem to find a way to print
the row numbers..  is there a way to do that.

this document has 11 pages horizontally, and total pages for printing
is 220,  having row numbers would be VERY helpful.

Any way to do that easily?

thank again,
gary


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Dave Peterson  
View profile  
 More options Jul 24 2004, 10:58 am
Newsgroups: microsoft.public.excel.newusers
From: Dave Peterson <ec35...@msn.com>
Date: Sat, 24 Jul 2004 09:58:21 -0500
Local: Sat, Jul 24 2004 10:58 am
Subject: Re: printing row numbers in Excel 97
File|page setup|sheet tab
check that box for "row and column headings"

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.

A helper column (new column A) filled with formulas:

=row()

niteowl wrote:

> Hi again,

> along with the gridline challenge, I can't seem to find a way to print
> the row numbers..  is there a way to do that.

> this document has 11 pages horizontally, and total pages for printing
> is 220,  having row numbers would be VERY helpful.

> Any way to do that easily?

> thank again,
> gary

--

Dave Peterson
ec35...@msn.com


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
niteowl  
View profile  
 More options Jul 24 2004, 11:27 am
Newsgroups: microsoft.public.excel.newusers
From: niteowl <nite...@NOniteowlproductionsSPAM.com>
Date: Sat, 24 Jul 2004 11:27:02 -0400
Local: Sat, Jul 24 2004 11:27 am
Subject: Re: printing row numbers in Excel 97
ok, tried that,  I had done that before, but it's only showing the
column headings, actually I set that up above in the "Rows to repeat
at top" setting....

should I undo that?

The options for the "row and headings" are:

none
at end of sheet
as displayed on sheet

I picked "as displayed on sheet", right????

thanks,
gary

On Sat, 24 Jul 2004 09:58:21 -0500, Dave Peterson <ec35...@msn.com>
wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "printing row numbers in Excel 97 - GOT IT!!! answer inside" by niteowl
niteowl  
View profile  
 More options Jul 24 2004, 11:29 am
Newsgroups: microsoft.public.excel.newusers
From: niteowl <nite...@NOniteowlproductionsSPAM.com>
Date: Sat, 24 Jul 2004 11:29:43 -0400
Local: Sat, Jul 24 2004 11:29 am
Subject: Re: printing row numbers in Excel 97 - GOT IT!!! answer inside
Got it!!!!

It was set to "Draft Quality", when I unticked those, it displays
perfectly now.

Thanks for the help!!!

gary

On Sat, 24 Jul 2004 09:58:21 -0500, Dave Peterson <ec35...@msn.com>
wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "printing row numbers in Excel 97" by Debra Dalgleish
Debra Dalgleish  
View profile  
 More options Jul 24 2004, 11:30 am
Newsgroups: microsoft.public.excel.newusers
From: Debra Dalgleish <d...@contexturesXSPAM.com>
Date: Sat, 24 Jul 2004 11:30:51 -0400
Local: Sat, Jul 24 2004 11:30 am
Subject: Re: printing row numbers in Excel 97
In File>Page Setup, on the Sheet tab, remove the check mark from 'Draft
quality', if there is one.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
anonym...@discussions.microsoft.com  
View profile  
 More options Jul 24 2004, 5:36 pm
Newsgroups: microsoft.public.excel.newusers
From: <anonym...@discussions.microsoft.com>
Date: Sat, 24 Jul 2004 14:36:40 -0700
Local: Sat, Jul 24 2004 5:36 pm
Subject: printing row numbers in Excel 97
Go to file, page setup, click on sheet tab.  You should
have some boxes you can check, check the gridlines box
and print row and column headings


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google