Slider moves much too fast

Hi Ken.

Excel normally looks at the data and identifies the portion of the spreadsheet that contains data. Sometimes this will not be accurate. There might actually be some extraneous data that was inadvertently entered way down in the sheet or sometimes there may be some kind of unnecessary data if the spreadsheet was created by some other program. When this happens, you have to remove all of that data so that Excel can accurately assess the correct data range in your spreadsheet.

The typical procedure is as follows.

1. Select the first blank Row after the data you want to keep by clicking on the row number.
2. Hold down CTRL and SHIFT and press the down arrow on the keyboard which will select all of the rows from your starting row to the end of the sheet.
3. Optional: Press delete on the keyboard to delete any data that might be randomly entered in those rows.
4. Right-click and select Delete to delete all of the rows. They will still appear, but Excel now knows that they are not part of the data.
5. Optional: Select the first column to the right of your data, use CTRL+SHIFT+right arrow to select all of the columns to the right of the data and hit Delete on the keyboard and right-click and select Delete.
6. You will not likely see any change after doing this until you save the file, close it, and re-open it.

second reply: the clear contents worked on most of the worksheets, but not all. I am pretty sure I cleared every cell on the sheet but still experiencing problem.

Well, the "Clear Contents" suggestion seemed to work. When I experience this trouble, the slider is very small. After clearing the contents from blank cells, the slider is very long and works properly. So, will try on all of my other workbooks. thanks

I've had similar issues that have been very hard to resolve if at all. They have, I think, always come from files produced from an external program. So, a couple other ideas.

Select all of the unused columns and when you right-click select Clear Contents before doing the other steps. That may clear some things that delete will not.

Always be sure to save and close the file immediately. These changes will not take effect until the file is re-opened.

Other things that I see but don't know if they will actually make a difference but would be worth a try include:

Return all of those columns to General format.

Make sure that there are no Conditional Formats that refer to those columns.

Make sure that there are no Named Ranges that include those columns.

If there are Pivot Tables make sure that they don't include those columns in the range. Check by selecting a cell in the Pivot Table, go to the Pivot Table Analyze ribbon, click on Change Data Source and you can see what range is selected.

Other questions:

Does this happen only sometimes (you described it as often in the question)?

Does this happen only in this sheet or workbook or in all workbooks.

Another solution is to copy all of the data, if possible, to paste into a new workbook. However, if this is happening in all workbooks that obviously will not be effective.

Finally, go ahead and run through the steps to select all of the columns, clear contents, delete data, delete columns, save, and close even several times. I've had some that didn't seem to work and then at a later time I came back and did it again and it resolved itself. Sometimes it is a mystery.

Well, still same problem. I cleared all unused cells on worksheet and slider still speeds way far out into infinity (actually, just to AEW. But it is so fast that you have no control to slow it down.