adjusting scroll bar size and keeping page setup when copying pages

[Jeremy Oldham]

Hello,
I was wondering how you change the scroll bar size
on excel doc. The pages that i use only go down to about
row 65 but the bar on the left is very small and if i drag
it down even 1/2 inch i'm on row 500. The other question i
have is when i copy a page and paste in a new workbook
each month i loose all of my page settings, ie. page
brakes,print area,and other formats. Is there any way to
avoid this. Any help you can provide will be greatly
appreciated.Thank you,
Jeremy

 

[Andy B]

Hi

Excel remembers which cells you have used in each sheet. To reset this
memory you need to delete all unused cells on the sheet, save close and
reopen. I use a macro to reset the used range, which means you don't need to
go through all that:

Sub Reset_Range()
ActiveSheet.UsedRange
End Sub

You can then assign this to a toolbar button.

If you want to copy a page to another workbook, the best way is to
right-click on the sheet's tab and then click 'Create copy' and select the
book name at the top of the dialog box.

Andy.