Message from discussion
printing row numbers in Excel 97
Message-ID: <410280AB.1090903@contexturesXSPAM.com>
Date: Sat, 24 Jul 2004 11:30:51 -0400
From: Debra Dalgleish <d...@contexturesXSPAM.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: printing row numbers in Excel 97
References: <1qt4g0dcliegkothc7qqiq8dmkdnsrvuer@4ax.com> <4102790D.7EC9D03E@msn.com> <bov4g0tcc24ljhj6gm44scpvp7dhccda6o@4ax.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.excel.newusers
NNTP-Posting-Host: hse-ottawa-ppp326011.sympatico.ca 64.231.140.178
Path: g2news1.google.com!news2.google.com!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed.cwix.com!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
Lines: 1
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
|
