#1   Report Post  
Cheri
 
Posts: n/a
Default 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
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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


  #3   Report Post  
Cheri
 
Posts: n/a
Default

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



  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll Bar in Shared workbook Ronil Patel Excel Discussion (Misc queries) 2 December 8th 04 01:49 AM
Scroll bars (vertical and horizontal). Doc Excel Discussion (Misc queries) 2 December 7th 04 03:33 PM
scroll lock PCOR Excel Discussion (Misc queries) 6 December 5th 04 08:08 PM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 08:55 PM
eliminate scroll bars where lists are short, show all choices rtejral Excel Discussion (Misc queries) 1 November 29th 04 09:01 PM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"