View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do I change the size of vertical scroll bar

If you have a workbook template named book.xlt in your XLStart folder, then
excel will use that when you create a new workbook by clicking on the new icon
on the standard toolbar.

And you can do anything you want with the worksheets in book.xlt--include extend
the range to way past what excel would think.

And if you create another template file and name it Sheet.xlt (also in your
XLStart folder), then any new worksheet added to an existing workbook will
inherit whatever you have in that template file.

Peg B wrote:

This is helpful. However, do you know of a way to make that range a
"default"? My excel always opened with an ability to scroll down hundreds of
rows. Something happened when I pasted a copied excel spreadsheet into a new
worksheet. Now it is only allows me to scroll to the last row of the
worksheet.

"Peg B" wrote:

My vertical scroll bar only allows me to scroll to the last row that has data
in it. I want to be able to scroll down to any row I want, whether I have
data there or not.

I was able to do this until today. I copied an excel spreadsheet from a
word doc and pasted it into a new Excel workbook. Now the vertical scroll
bar only allows me to scroll to the last row with data. The mouse wheel will
let me scroll down further, but not the scroll bar.

How do I reset the scroll bar to become "small" so that I can scroll down
further?


--

Dave Peterson