Quote:
Originally Posted by ArviLaanemets
What the heck is "short vertical scrollbar"? Do you mean the rectangular part on right scrollbar you click on to scroll up/down? This one changes dimension accordingly the number or rows in used area on sheet.
|
Yes, the rectangular part on the right scrollbar. It's shaped like an elongated oval. On some tabs of this seven-tab workbook, dragging that little oval is perfectly responsive. If I use my mouse to drag the scroll button down (on this tab, the sheet has only 39 rows of data), it moves fast from the top to the bottom. There are still numerous uninhabited rows below row 39, but they have no effect on the scrolling.
Quote:
Originally Posted by ArviLaanemets
When this is what you are asking about, then getting it short means, that you really have something entered into some cell way down. Use Ctrl + End to locate last used cell on sheet.
In case it will be on the max allowed column or max allowed row for your Excel version and there is not any real entry, then it means for some column you have defined something what makes Excel to mark all rows used for this column (I have encountered such cases in past, but I din't remember anymore what kind of thing this was. And having it defined for entire row/column means, you can get rid of it only deleting rows/columns fully - otherwise the problem is recreated). When this is the case, then the simplest way to correct it is to create a new sheet, copy all data from range you count the proper one only (values, formulas, formats, etc.) from compromised sheet to new one, and then delete the compromised sheet.
When otherwise, then either clear any info from last cell (e.g. dragging some unused cell over it), or delete all rows (when the last cell was in some column used for your real data) or columns (when the last used cell was in some column to right of any columns used for your real data) from last row/column below/right of your real data until row/column of last used cell your did locate, or until last row/cell of sheet.
|
For one of the sheets that's exhibiting the problem, I selected all the rows with data, that is, rows 1 through 422 (I did NOT select the whole sheet), copied, and pasted to a new tab/sheet using Paste Special>All, then also pasted column widths. Nothing changed. The pasted content still has a very short scroll bar (or maybe it's a very long scroll bar; semantics), by which I mean dragging the scroll "button" down is nearly impossible, because it scrolls all 422 rows when it's moved about 1/16" (assuming the workbook is full or nearly full screen on a 27" monitor).
If I have some data entered in a cell "way down," it should not have been copied when I selected only 422 rows.
I've tried the following a few times now:
Ctrl+End shows me the last row with data, which is 422 as expected. Selecting row 423 and using Ctrl+Shift+down arrow selects rows 423 to 1048576. Then on the Home tab>Cells section, using Delete Sheet Rows OR Delete Cells deletes the rows (well, it deletes any data in the rows), but it doesn't fix the problem with the short scroll bar.
Thanks.