ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Slider bar (https://www.excelbanter.com/excel-discussion-misc-queries/60585-slider-bar.html)

pj

Slider bar
 
How do you get the slider bar on the right side to go to the end of where the
data is instead of way past where the data ends.
There is no other data beyond where my actual data ends and I have deleted
the extra lines but the slider still wont move up.

Thanks - PJ

Dave Peterson

Slider bar
 
Try resetting the last used cell.
Debra Dalgleish shows techniques:
http://contextures.com/xlfaqApp.html#Unused

pj wrote:

How do you get the slider bar on the right side to go to the end of where the
data is instead of way past where the data ends.
There is no other data beyond where my actual data ends and I have deleted
the extra lines but the slider still wont move up.

Thanks - PJ


--

Dave Peterson


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com