Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim Patterson
 
Posts: n/a
Default Size of a Worksheet

Hello,
I have a worksheet that although there are only 56 rows with entries, the
vertical scoll bar adjustor is very small and scrolls all the way down to row
65,000. The worksheet displays approx 160 rows at a time.Other sheets in the
workbook have a large scroll bar adjustor and only show approx 32 rows.

Does anyone have any idea what is causing this?

Thanks in Advance,
--
Jim Patterson
  #2   Report Post  
Henrik
 
Posts: n/a
Default Size of a Worksheet

Check you zoom factor on each sheet...

The shortcut is
Alt - V - Z

"Jim Patterson" wrote:

Hello,
I have a worksheet that although there are only 56 rows with entries, the
vertical scoll bar adjustor is very small and scrolls all the way down to row
65,000. The worksheet displays approx 160 rows at a time.Other sheets in the
workbook have a large scroll bar adjustor and only show approx 32 rows.

Does anyone have any idea what is causing this?

Thanks in Advance,
--
Jim Patterson

  #3   Report Post  
Jim Patterson
 
Posts: n/a
Default Size of a Worksheet

Thanks, I appreciate it very much
--
Jim Patterson


"Henrik" wrote:

Check you zoom factor on each sheet...

The shortcut is
Alt - V - Z

"Jim Patterson" wrote:

Hello,
I have a worksheet that although there are only 56 rows with entries, the
vertical scoll bar adjustor is very small and scrolls all the way down to row
65,000. The worksheet displays approx 160 rows at a time.Other sheets in the
workbook have a large scroll bar adjustor and only show approx 32 rows.

Does anyone have any idea what is causing this?

Thanks in Advance,
--
Jim Patterson

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
Modify cell size in worksheet Neal Excel Worksheet Functions 0 October 19th 05 09:57 PM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
How do I apply a default size to all comments in Excel worksheet? Alt0471 Excel Discussion (Misc queries) 1 May 25th 05 08:57 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 03:45 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"