Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll Bar in Shared workbook | Excel Discussion (Misc queries) | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) | |||
scroll lock | Excel Discussion (Misc queries) | |||
How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel | |||
eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) |