Adjusting the Scroll Bar; Special Case

Question

Hello,

I would like to know another method to adjust the Excel scrollbar other than the one that involves selecting all the rows (or columns) from the last filled cell, then deleting them and saving/closing the file...
I have been using this method for years, but I realize that there is at least one special case where it does not work and it annoys me a bit: when copying cells on which we have changed the default dimensions and to which we have applied word wrap.

Do you have a manual method to apply or do I need to use a macro?

Thank you in advance!

danielc0 · Answer

Hello,  Run the macro only once:  Sub test() ActiveSheet.ScrollArea = "A1:C10" End Sub  Set the range of your choice. This only applies to the active sheet.  Best regards.  Daniel

eriiic · Answer

Hello,

a cell that you modified (format or height) counts the same as if it were filled for the evaluation of the used range.
So either you delete them (manually or via macro), or you deal with it.
eric

By constantly trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it does happen!!!), remember to mark it as resolved. Thank you.

Calice12345 · Answer

Hi Daniel, Eric,

Thank you for getting back to me! As I said, it's really a special case and I can manage, but I really like to completely understand what's going on...

Daniel:
I had already seen your method with the ScrollArea and although there is a slight improvement, it is still not as good as Excel's usual adjustment using the method of deleting the bottom rows.
For example, in my case, my last filled row (around 1300) is about halfway down the scroll bar. If I go too far down when I scroll, it will "return" to the center of the screen and I will be right at my last row... It is true, once again, that it’s a bit better than being left in the middle of nowhere, but in fact, it only reduces the size of the bar (especially if we have a lot of rows).

Eric:
Sorry, I didn’t really understand your explanation... When you talk about a filled cell, does that mean it acts as if it contains the maximum number of characters that can be put in an Excel cell?
In any case, I tested something else thanks to your response because I thought I had tried everything; I’m not sure all the steps are necessary but it works even if it remains a bit of a convoluted process... Duplicate the sheet, delete all the rows except the first ones, duplicate this new sheet and then paste the cells I deleted from the original sheet...

If there’s something simpler, don’t hesitate! :)

Have a great weekend and thanks again!

Adjusting the Scroll Bar; Special Case

3 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.