columns

F

frank

two questions:
1. Is there a way to print the row numbers without
printing the column letters.

2. Is there a way to limit how far down the scroll bar
goes on EXCEL.
 
D

David McRitchie

Hi Frank,
Part 1, No
but you could use a helper column with a the row number
=ROW()
or something adjusted to your preference
=ROW()-1

Part 2, yes with a macro (example from VBA Help)
Worksheets(1).ScrollArea = "a1:f10"

But perhaps you have a problem with the last cell that
you are trying to hide by limiting the scroll area
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top