Additional step for Option #2: It has been identified that using the Clear All method doesn't clear all the possible issues. As an extra step, repeat the same process, but Delete the necessary rows and columns. This appears to fix some issues which Clear All does not.
This video has saved me hours of time. AMAZING, thank you sooooo much. My file size suddenly went from 1220KB to 128000KB and so it was running REALLY slow. After following the steps in this video, my file size is back to 1220KB. I LOVE YOU whoever you are Excel off the Grid.!
i found this video AFTER spending 2 hours going through different sources (websites and videos). thank you! my excel had the last 2 issues. thank you for the complete and easy to understand video.
Thank you very much . This video save my day. My story was badly positioned commentary. I am use code that automatically add them as I fill output sheet. At end of job I used “Row.Autofit” (which change high of rows). But commentary stayed spread on sheet in old position and that was reason why vertical scrollbar remained tiny. *Lessons learned - use auto format of size and position for commentary next time (at end of sheet VBA code).* Live long and prosper :)
yes! thank you, the 3rd step worked for me, I was close to giving up, I had millions of rows on my sheet and it made the sheet extremely slow and laggy and was pretty much un-usable to add any data
Thank you, and thank you and thank you! I almost lost my mind trying to fix my data table. It turned out the comments were pushed somehow 2000 lines below my data. How, when, why, I don't know. Now it is fixed :)
✅Good info, thanks for sharing 👍 An easy way of detecting if you have a used range issue is clicking CTRL+END when on a sheet - this will jump to whatever Excel things is the end of the used range. If this is way beyond your data you know you have cells to delete!
Thank you so much your video was very useful, I applied all options in my excel sheet. First, it reduced the file size from 7189KB to 1912KB, Second, the working file is much faster than before. In my file, I have 2650 row cases now if I scroll down it goes directly to the identified cases that I want, not to the unknown empty space as before.
hi Mark. Excellent video. I have a question which is not really to the scroll bar of Excel table under this topic, but scroll bar to the "Queries and Connection" pane . I have an excel table with many power queries. When I refresh all with the "Queries and Connection" chosen, the right pane on the most right-hand side show all the queries list and shows which one is being refreshed. But when refreshed, the stroll bar for the Queries and Connection pane is frozen, I cannot see which query is being refreshed at the moment. I am wondering if you have any solution to this issue. Thank you.
The panes in the right do have some issues (Queries and Connections has a few bugs that I’m aware of). My guess is that this is also bug. Please report it to Microsoft through Excel’s help menu. Sorry, but there is no workaround that I’m aware of.
Nice video, but none of these worked for me to decrease the size of the vertical scroll bar. I ended up copying all the cells to a new spreadsheet to fix it.
@@ExcelOffTheGrid None of these worked for me either, also tried the delete rows - still not . Interestingly though the VBA editor showed what looks like a special ribbon format macro (sheet was partially copied from a client). I might try copying the sheet to another workbook and delete the VBA code. Any comment? PS - the depth BTW is unusually long, 175.000 rows.
I solved it with a single move, I added a column at the end of the table and then I went down with a double click on the automat column, then I deleted the column and the bar returned to the size of the page. Anyway, well documented the video. congrats
None of those options worked. I looked at several videos and exhausted all avenues. The only thing that fixed the issue was copying and pasting all applicable data in a new worksheet, and deleting the old one.
@@ExcelOffTheGrid Hi, unfortunately not. That file is miles away now lol! I was able to use your advice in a later file I created, so I know it works now. Thanks!
No, definitely not the fastest solution. That is exactly what we want to avoid. That could break hundreds of formulas… which could takes days to fix and cause a huge number of errors.
I had this problem and none of these solutions worked. However, i just discovered a fourth solution. Find the lowest row toy actually need then literally delete all the rows below (using Ctrl, Shift, Arrows then select "delete sheet rows") to the very bottom of the sheet. this took my computer about 1 minute to do. After that save, exit and reload. Note IMPORTANT! Make a back up copy of your file first in case you accidentally permanently delete a whole bunch of your work!
You make a good point about backing up. That is critical :-) There should be a pinned comment below the video which gives the same delete method. It's great to get so many different ways to solve a problem :-)
This video has saved me hours of time. AMAZING, thank you sooooo much. My file size suddenly went from 1220KB to 128000KB and so it was running REALLY slow. After following the steps in this video, my file size is back to 1220KB. I LOVE YOU whoever you are Excel off the Grid.!
Additional step for Option #2:
It has been identified that using the Clear All method doesn't clear all the possible issues. As an extra step, repeat the same process, but Delete the necessary rows and columns.
This appears to fix some issues which Clear All does not.
Yes! That was the one missing step! Thank-you so much!
This video has saved me hours of time. AMAZING, thank you sooooo much. My file size suddenly went from 1220KB to 128000KB and so it was running REALLY slow. After following the steps in this video, my file size is back to 1220KB. I LOVE YOU whoever you are Excel off the Grid.!
Good work, I'm glad I could help. ♥
This video is invaluable. Thank you.
For me, it was the note box issue - option 4.
Somehow a note box got extended to hundreds of thousands of rows.
You've solved it. Great news :-)
Thank you so much. I kept doing ''delete'' instead of ''clear'' and it didn't help at all. Thanks for being straight to the point!
Glad I could help.
Thank you. Additional step with Option #2 did the trick. This also removed the freezing issue while pasting in the sheet.
Great news!! How are you going to use those extra minutes that you’ve just saved? Finishing work a little bit earlier I hope 😀
i found this video AFTER spending 2 hours going through different sources (websites and videos). thank you!
my excel had the last 2 issues. thank you for the complete and easy to understand video.
Yay! Great news. Glad it helped! 😁
Thank you very much . This video save my day. My story was badly positioned commentary. I am use code that automatically add them as I fill output sheet. At end of job I used “Row.Autofit” (which change high of rows). But commentary stayed spread on sheet in old position and that was reason why vertical scrollbar remained tiny.
*Lessons learned - use auto format of size and position for commentary next time (at end of sheet VBA code).*
Live long and prosper
:)
There are lots of quirks in Excel - glad I could help with this one :-)
Thank you. Very helpful.
You're welcome 😀
Thank you very much. I had to go through all the items to get the result.
You are welcome! Glad I could help.
I've been looking for a few months to solve this problem. Thanks a lot for the help!
Glad I could help :-)
Thanks, it worked for me, but i needed to save, close and reopen in order to see the changes.
Thanks, that’s useful to know that sometimes there are extra steps.
works for me in "clear all" step, thanks for the trick
Yay!! Great news, no more scrolling.
Option 3 worked for me! Thank you! You saved me
Great news. You’re welcome. ✅
Thank you so much! The Activesheet.Usedrange really helped!
Good stuff - glad I could help 😀
yes! thank you, the 3rd step worked for me, I was close to giving up, I had millions of rows on my sheet and it made the sheet extremely slow and laggy and was pretty much un-usable to add any data
Yay!! Good work 🎉
Thanks for the help!! Option #2 did the trick!
Fantastic! Good work :-)
Video from out of syllabus.. Well explanations..
Thanks you
That's work. Thank you so much!
You’re welcome.
Thank you, and thank you and thank you! I almost lost my mind trying to fix my data table. It turned out the comments were pushed somehow 2000 lines below my data. How, when, why, I don't know. Now it is fixed :)
Woop! Woop! Good job. Now no more wasted time scrolling.
This is a big help! Thanks for sharing it.
Thanks - I’m glad it helped.
Saved me so many times! Thank you!
No problem 👍
Very good!
Thank you! Glad you liked it.
Saved me hours! Thank you!
You’re welcome. Glad I could help.
✅Good info, thanks for sharing 👍 An easy way of detecting if you have a used range issue is clicking CTRL+END when on a sheet - this will jump to whatever Excel things is the end of the used range. If this is way beyond your data you know you have cells to delete!
Thank you very much
You’re welcome.
Thanks buddy it worked...
Great news 😀
Thanks,you save my life!!
You’re welcome. 👍
Great video i ever seen for excel..👍
Thanks, Glad you liked it! 😁
Just what I was looking for.
Great news - glad it helped :-)
It worked. My added a note on the last cell. lol..Thanks
Excellent! That scroll wheel won't get worn out now 😀
Lifesaver; thank you.
You're welcome!
Thank you so much your video was very useful,
I applied all options in my excel sheet.
First, it reduced the file size from 7189KB to 1912KB,
Second, the working file is much faster than before.
In my file, I have 2650 row cases now if I scroll down it goes directly to the identified cases that I want, not to the unknown empty space as before.
Yay! Great news 👍
Thank you 😌😌
Thanks a lot, you helped me with the issue I was facing (obviously with the last Option ^_^)
Glad I could help! :-)
Thank you
hi Mark. Excellent video. I have a question which is not really to the scroll bar of Excel table under this topic, but scroll bar to the "Queries and Connection" pane . I have an excel table with many power queries. When I refresh all with the "Queries and Connection" chosen, the right pane on the most right-hand side show all the queries list and shows which one is being refreshed. But when refreshed, the stroll bar for the Queries and Connection pane is frozen, I cannot see which query is being refreshed at the moment. I am wondering if you have any solution to this issue. Thank you.
The panes in the right do have some issues (Queries and Connections has a few bugs that I’m aware of). My guess is that this is also bug. Please report it to Microsoft through Excel’s help menu.
Sorry, but there is no workaround that I’m aware of.
many thanks sir! this really helpful :)
It’s a frustrating little problem, glad I could help 😀
I lost hope but then I reached the 4th section. Deleted all the notes and problem solved!
Yay!! Great news 😀
👉🤯👈... 👌👌 Mark!
Supper...............many many thanks
It's a frustrating little problem isn't it. Glad I could help. :-)
Nice video, but none of these worked for me to decrease the size of the vertical scroll bar. I ended up copying all the cells to a new spreadsheet to fix it.
Would you be willing to send a copy of the workbook to me. Then I can look to see what might be causing it.
@@ExcelOffTheGrid None of these worked for me either, also tried the delete rows - still not . Interestingly though the VBA editor showed what looks like a special ribbon format macro (sheet was partially copied from a client). I might try copying the sheet to another workbook and delete the VBA code. Any comment?
PS - the depth BTW is unusually long, 175.000 rows.
@@roadgent7921 Please reach out to me via my blog contact page. As I would like to see the file and try to find out the issue.
@@ExcelOffTheGrid OK, I'll do that. Thanks. Ps - will be 2 or 3 days.
I solved it with a single move, I added a column at the end of the table and then I went down with a double click on the automat column, then I deleted the column and the bar returned to the size of the page. Anyway, well documented the video. congrats
Well done in solving it. Great work.
Yes thank
Still does not work for me, very strange
🤔 very odd.
Which version of Excel are you using?
@@ExcelOffTheGrid The newest one sir
None forked for me and I still have horizontal scroll, so annoying.
I have the opposite problem! I can only scroll right far enough to see my last filled column+1 column but I wish it would go further! Any ideas?
Without seeing the file it's difficult to know. It could be:
1) Scroll area is locked
2) Hidden columns to the right of the data
My vertical scroll bar is not working what to do
Sorry, but without seeing the file it's difficult to know.
None of those options worked. I looked at several videos and exhausted all avenues. The only thing that fixed the issue was copying and pasting all applicable data in a new worksheet, and deleting the old one.
Can you send me the file so I can take a look at the file. Please reach out through the contact page on my website.
@@ExcelOffTheGrid Hi, unfortunately not. That file is miles away now lol!
I was able to use your advice in a later file I created, so I know it works now. Thanks!
Activesheet.Usedrange
hermoso
Fastes solution... Copy & Paster all in-use content to another worksheet. Delete the old one and rename the new one.
No, definitely not the fastest solution.
That is exactly what we want to avoid.
That could break hundreds of formulas… which could takes days to fix and cause a huge number of errors.
I had this problem and none of these solutions worked. However, i just discovered a fourth solution. Find the lowest row toy actually need then literally delete all the rows below (using Ctrl, Shift, Arrows then select "delete sheet rows") to the very bottom of the sheet. this took my computer about 1 minute to do. After that save, exit and reload. Note IMPORTANT! Make a back up copy of your file first in case you accidentally permanently delete a whole bunch of your work!
You make a good point about backing up. That is critical :-)
There should be a pinned comment below the video which gives the same delete method. It's great to get so many different ways to solve a problem :-)
This video has saved me hours of time. AMAZING, thank you sooooo much. My file size suddenly went from 1220KB to 128000KB and so it was running REALLY slow. After following the steps in this video, my file size is back to 1220KB. I LOVE YOU whoever you are Excel off the Grid.!
Thanks Dinah - glad I could help. 👍