adjusting scroll bar size and keeping page setup when copying pages

  • Thread starter Thread starter Jeremy Oldham
  • Start date Start date
J

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
 
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.
 
Back
Top