ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vertical scroll bar length (https://www.excelbanter.com/excel-discussion-misc-queries/249490-vertical-scroll-bar-length.html)

Aura

Vertical scroll bar length
 
I have the problem, that my vertical scroll bar takes me down to row number
+60000 but I only have about 700 columns of data.

I tried to delete all the extra cells by marking row 701 and pressing crtl +
shift + arrow down (to take me to the buttom), right click and then press
delete row.

However, this does not solve the problem.

Any ideas?

Jacob Skaria

Vertical scroll bar length
 
When you delete make sure you delete one row/column extra from the used
range. Once you delete columns and rows, save the file. Try close and re-open
the file.

Check out
http://www.contextures.com/xlfaqApp.html#Unused

If this post helps click Yes
---------------
Jacob Skaria


"Aura" wrote:

I have the problem, that my vertical scroll bar takes me down to row number
+60000 but I only have about 700 columns of data.

I tried to delete all the extra cells by marking row 701 and pressing crtl +
shift + arrow down (to take me to the buttom), right click and then press
delete row.

However, this does not solve the problem.

Any ideas?



All times are GMT +1. The time now is 04:55 AM.

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