ExcelBanter - How do you reset vertical scoll bar to range of data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you reset vertical scoll bar to range of data? (https://www.excelbanter.com/excel-discussion-misc-queries/162333-how-do-you-reset-vertical-scoll-bar-range-data.html)

AWM1957

How do you reset vertical scoll bar to range of data?

Gord Dibben

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:

All times are GMT +1. The time now is 02:24 AM.