View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do you reset vertical scoll bar to range of data?

Delete all columns to the right of data and all rows below data.

Then Save the workbook.

In older versions it was necessary to save/close then re-open to see changes.


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 11:53:03 -0700, AWM1957
wrote: