printing row numbers in Excel 97
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
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
You must
Sign in before you can post messages.
You do not have the permission required to post.
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
You must
Sign in before you can post messages.
You do not have the permission required to post.
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:
>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
You must
Sign in before you can post messages.
You do not have the permission required to post.
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:
>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
You must
Sign in before you can post messages.
You do not have the permission required to post.
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.
niteowl wrote:
> 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:
>>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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You must
Sign in before you can post messages.
You do not have the permission required to post.
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
>-----Original Message-----
>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 >.
You must
Sign in before you can post messages.
You do not have the permission required to post.