Message from discussion
printing row numbers in Excel 97
Path: g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local1.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sat, 24 Jul 2004 10:27:02 -0500
From: niteowl <nite...@NOniteowlproductionsSPAM.com>
Newsgroups: microsoft.public.excel.newusers
Subject: Re: printing row numbers in Excel 97
Date: Sat, 24 Jul 2004 11:27:02 -0400
Message-ID: <bov4g0tcc24ljhj6gm44scpvp7dhccda6o@4ax.com>
References: <1qt4g0dcliegkothc7qqiq8dmkdnsrvuer@4ax.com> <4102790D.7EC9D03E@msn.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 48
X-Trace: sv3-UPoseKwIomyOR753UDA4bYHA+wz6H8DUWNM1WUXkpSBQOcuZ1y7MYmuK7RWvsmFSFP/9QTsb0IUaaNO!TH63c5QeHcnATggk5qdYHhlT/FJFSsS2lh40MhpxvlJwo7WkJVNCMiW3vFBZHO26M1Hb
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
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
|
