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.
@toddpaben4654
2 жыл бұрын
Yes! That was the one missing step! Thank-you so much!
@sabinbasukala
2 жыл бұрын
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.!
@ExcelOffTheGrid
2 жыл бұрын
Good work, I'm glad I could help. ♥
@coryhames9331
3 жыл бұрын
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.
@ExcelOffTheGrid
3 жыл бұрын
You've solved it. Great news :-)
@antoinehubs
6 ай бұрын
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!
@ExcelOffTheGrid
6 ай бұрын
Glad I could help.
@atagofan6845
8 ай бұрын
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.
@ExcelOffTheGrid
8 ай бұрын
Yay! Great news. Glad it helped! 😁
@arkasaha4321
3 жыл бұрын
Thank you. Additional step with Option #2 did the trick. This also removed the freezing issue while pasting in the sheet.
@ExcelOffTheGrid
3 жыл бұрын
Great news!! How are you going to use those extra minutes that you’ve just saved? Finishing work a little bit earlier I hope 😀
@ReaLityBlue
2 жыл бұрын
Thanks, it worked for me, but i needed to save, close and reopen in order to see the changes.
@ExcelOffTheGrid
2 жыл бұрын
Thanks, that’s useful to know that sometimes there are extra steps.
@antoninditrych4860
3 жыл бұрын
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 :)
@ExcelOffTheGrid
3 жыл бұрын
There are lots of quirks in Excel - glad I could help with this one :-)
@ninogunjaca1559
2 жыл бұрын
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 :)
@ExcelOffTheGrid
2 жыл бұрын
Woop! Woop! Good job. Now no more wasted time scrolling.
@Lb-ri5wr
2 жыл бұрын
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
@ExcelOffTheGrid
2 жыл бұрын
Yay!! Good work 🎉
@Up4Excel
2 жыл бұрын
✅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!
@etgarequator2671
2 жыл бұрын
works for me in "clear all" step, thanks for the trick
@ExcelOffTheGrid
2 жыл бұрын
Yay!! Great news, no more scrolling.
@briggo0
Жыл бұрын
Thank you. Very helpful.
@ExcelOffTheGrid
Жыл бұрын
You're welcome 😀
@Sri-Nivas
3 жыл бұрын
Video from out of syllabus.. Well explanations..
@ExcelOffTheGrid
3 жыл бұрын
Thanks you
@nataliiaiatsenko7779
2 жыл бұрын
Thank you very much. I had to go through all the items to get the result.
@ExcelOffTheGrid
2 жыл бұрын
You are welcome! Glad I could help.
@sarahlee988
2 жыл бұрын
Option 3 worked for me! Thank you! You saved me
@ExcelOffTheGrid
2 жыл бұрын
Great news. You’re welcome. ✅
@italodaviddossantos
3 жыл бұрын
I've been looking for a few months to solve this problem. Thanks a lot for the help!
@ExcelOffTheGrid
3 жыл бұрын
Glad I could help :-)
@CeciliaKS13
2 жыл бұрын
Thanks for the help!! Option #2 did the trick!
@ExcelOffTheGrid
2 жыл бұрын
Fantastic! Good work :-)
@SenKnowsBest
Жыл бұрын
Saved me hours! Thank you!
@ExcelOffTheGrid
Жыл бұрын
You’re welcome. Glad I could help.
@ranveerk9893
3 жыл бұрын
Thank you so much! The Activesheet.Usedrange really helped!
@ExcelOffTheGrid
3 жыл бұрын
Good stuff - glad I could help 😀
@EvainWanderland
2 жыл бұрын
Saved me so many times! Thank you!
@ExcelOffTheGrid
2 жыл бұрын
No problem 👍
@miriamsels2326
10 ай бұрын
I lost hope but then I reached the 4th section. Deleted all the notes and problem solved!
@ExcelOffTheGrid
10 ай бұрын
Yay!! Great news 😀
@kebincui
Жыл бұрын
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.
@ExcelOffTheGrid
Жыл бұрын
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.
@user-rc8in8fs7o
Жыл бұрын
Thanks,you save my life!!
@ExcelOffTheGrid
Жыл бұрын
You’re welcome. 👍
@doikaru
Жыл бұрын
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
@ExcelOffTheGrid
Жыл бұрын
Well done in solving it. Great work.
@wmfield152
2 жыл бұрын
This is a big help! Thanks for sharing it.
@ExcelOffTheGrid
2 жыл бұрын
Thanks - I’m glad it helped.
@Ashumi
Жыл бұрын
That's work. Thank you so much!
@ExcelOffTheGrid
Жыл бұрын
You’re welcome.
@muzafar1892
3 жыл бұрын
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.
@ExcelOffTheGrid
3 жыл бұрын
Yay! Great news 👍
@sodadasisamson1366
2 жыл бұрын
Thanks buddy it worked...
@ExcelOffTheGrid
2 жыл бұрын
Great news 😀
@rudsofficial13
Жыл бұрын
Thank you very much
@ExcelOffTheGrid
Жыл бұрын
You’re welcome.
@pedrovasconcelos3204
Жыл бұрын
Very good!
@ExcelOffTheGrid
Жыл бұрын
Thank you! Glad you liked it.
@darylmorrison9723
2 жыл бұрын
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
2 жыл бұрын
Would you be willing to send a copy of the workbook to me. Then I can look to see what might be causing it.
@roadgent7921
2 жыл бұрын
@@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.
@ExcelOffTheGrid
2 жыл бұрын
@@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.
@roadgent7921
2 жыл бұрын
@@ExcelOffTheGrid OK, I'll do that. Thanks. Ps - will be 2 or 3 days.
@adhipshukla6632
3 жыл бұрын
Just what I was looking for.
@ExcelOffTheGrid
3 жыл бұрын
Great news - glad it helped :-)
@saurabhshukla4538
2 жыл бұрын
Great video i ever seen for excel..👍
@ExcelOffTheGrid
2 жыл бұрын
Thanks, Glad you liked it! 😁
@morningstar275
Жыл бұрын
It worked. My added a note on the last cell. lol..Thanks
@ExcelOffTheGrid
Жыл бұрын
Excellent! That scroll wheel won't get worn out now 😀
@yoursvc
Жыл бұрын
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
Жыл бұрын
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.
@yoursvc
Жыл бұрын
@@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!
@ExiledinElysium
Жыл бұрын
Lifesaver; thank you.
@ExcelOffTheGrid
Жыл бұрын
You're welcome!
@NewYears1978
5 ай бұрын
None forked for me and I still have horizontal scroll, so annoying.
@subhajittheboss
7 ай бұрын
Thank you 😌😌
@Xoyjaz
2 жыл бұрын
Still does not work for me, very strange
@ExcelOffTheGrid
2 жыл бұрын
🤔 very odd. Which version of Excel are you using?
@Xoyjaz
2 жыл бұрын
@@ExcelOffTheGrid The newest one sir
@oliverpls
3 жыл бұрын
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?
@ExcelOffTheGrid
2 жыл бұрын
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
@HandyHobby
3 жыл бұрын
Thank you
@tanmoysaha7440
2 жыл бұрын
My vertical scroll bar is not working what to do
@ExcelOffTheGrid
2 жыл бұрын
Sorry, but without seeing the file it's difficult to know.
@kaizennpvcoltd2379
3 ай бұрын
Yes thank
@lucabraga5667
3 жыл бұрын
Thanks a lot, you helped me with the issue I was facing (obviously with the last Option ^_^)
@ExcelOffTheGrid
3 жыл бұрын
Glad I could help! :-)
@spilledgraphics
2 жыл бұрын
👉🤯👈... 👌👌 Mark!
@zobairahmedshaik6385
4 жыл бұрын
Supper...............many many thanks
@ExcelOffTheGrid
4 жыл бұрын
It's a frustrating little problem isn't it. Glad I could help. :-)
@amirahayub9480
3 жыл бұрын
many thanks sir! this really helpful :)
@ExcelOffTheGrid
3 жыл бұрын
It’s a frustrating little problem, glad I could help 😀
@AhmedAAmer-sl6ku
3 жыл бұрын
Activesheet.Usedrange
@Opium2000
8 ай бұрын
Fastes solution... Copy & Paster all in-use content to another worksheet. Delete the old one and rename the new one.
@ExcelOffTheGrid
8 ай бұрын
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.
@MrHishim
2 жыл бұрын
hermoso
@chunkymonkey55555
3 жыл бұрын
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!
@ExcelOffTheGrid
3 жыл бұрын
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 :-)
@dinahcrellin983
3 жыл бұрын
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.!
Пікірлер: 103