columns

[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.

 

[Andy B]

Hi

1. You could use a helper column containing =ROW() to create your row
numbers.
2. The scroll bar will go down to the end of your 'used range'. To reset
your used range (if that is your problem) visit here for information
http://www.contextures.com/xlfaqApp.html#Unused

Hope this helps.

 

[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