Go to Google Groups Home    microsoft.public.excel.newusers
Re: printing row numbers in Excel 97

Debra Dalgleish <d...@contexturesxspam.com>

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