ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scroll bar (https://www.excelbanter.com/excel-discussion-misc-queries/1551-scroll-bar.html)

Cheri

Scroll bar
 
I have a workbook with two sheets - the first sheet has information in 130
rows and it scrolls down just right and stops at row 130. However, the
second sheet has the same information copied into it and it scrolls on the
row number side in regular speed, but the scroll bar itself on the right,
barely moves. Is there a way to adjust it so that it will move quickly
through the rows to the bottom like page 1?
--
~ Cheri

Frank Kabel

Hi
maybe the used range has to be reset. See:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany

"Cheri" schrieb im Newsbeitrag
...
I have a workbook with two sheets - the first sheet has information

in 130
rows and it scrolls down just right and stops at row 130. However,

the
second sheet has the same information copied into it and it scrolls

on the
row number side in regular speed, but the scroll bar itself on the

right,
barely moves. Is there a way to adjust it so that it will move

quickly
through the rows to the bottom like page 1?
--
~ Cheri



Cheri

Thank you so much - worked great. My supervisior thinks I'm an Excel guru -
little does she know I just know where to find the answers! This answer site
has been such a blessing to me!
Cheri

"Frank Kabel" wrote:

Hi
maybe the used range has to be reset. See:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany

"Cheri" schrieb im Newsbeitrag
...
I have a workbook with two sheets - the first sheet has information

in 130
rows and it scrolls down just right and stops at row 130. However,

the
second sheet has the same information copied into it and it scrolls

on the
row number side in regular speed, but the scroll bar itself on the

right,
barely moves. Is there a way to adjust it so that it will move

quickly
through the rows to the bottom like page 1?
--
~ Cheri




Gord Dibben

Cheri

You have mastered the secret of life!!

"Know where/how to find the answers"

Best thing I ever did was learn to read<g

Gord Dibben Excel MVP

On Wed, 8 Dec 2004 14:25:03 -0800, "Cheri"
wrote:

Thank you so much - worked great. My supervisior thinks I'm an Excel guru -
little does she know I just know where to find the answers! This answer site
has been such a blessing to me!
Cheri




All times are GMT +1. The time now is 08:20 PM.

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