ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Size of a Worksheet (https://www.excelbanter.com/excel-worksheet-functions/53362-size-worksheet.html)

Jim Patterson

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

Henrik

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


Jim Patterson

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



All times are GMT +1. The time now is 05:15 AM.

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