ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Resizing scroll box (https://www.excelbanter.com/excel-discussion-misc-queries/89416-resizing-scroll-box.html)

prodrafter

Resizing scroll box
 

Someone has opened an Excel file and scrolled all the way to the bottom
of the spreadsheet and now the scroll box is very thin and my data ends
about 1/4 to 1/3 way down. I know there is a way to re-set the
spreadsheet so the scroll box is more useable but can't remember nor
can I find it in the help file. Can anyone out there help me, please?

Thanks in advance:)


--
prodrafter
------------------------------------------------------------------------
prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287
View this thread: http://www.excelforum.com/showthread...hreadid=543460


Dave Peterson

Resizing scroll box
 
Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

prodrafter wrote:

Someone has opened an Excel file and scrolled all the way to the bottom
of the spreadsheet and now the scroll box is very thin and my data ends
about 1/4 to 1/3 way down. I know there is a way to re-set the
spreadsheet so the scroll box is more useable but can't remember nor
can I find it in the help file. Can anyone out there help me, please?

Thanks in advance:)

--
prodrafter
------------------------------------------------------------------------
prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287
View this thread: http://www.excelforum.com/showthread...hreadid=543460


--

Dave Peterson

prodrafter

Resizing scroll box
 

Thanks.
That did the trick.:)


--
prodrafter
------------------------------------------------------------------------
prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287
View this thread: http://www.excelforum.com/showthread...hreadid=543460



All times are GMT +1. The time now is 04:14 AM.

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