View original (French)

Reduce the size of the sliders in EXCEL

Solved
JNICO Posted messages 8 Status Membre -  
 luccio -
Hello,

When deleting cells on an Excel sheet, the scrollbars do not always resize.
How can I readjust the scrollbar size to match the end of the data when the cursor is at the edge of the area?

For now, I have to copy the data range to a new sheet, but that's not great; I'm sure one of you has a super simple tip...

Thanks

5 réponses

Réponse 1 / 5
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

I'm sure one of you has the super simple tip...
yes: save it ;-)

If you've deleted everything, a simple save of the file restores the scrollbar.
If that doesn't work, it means there are still non-empty cells. Delete all rows from Ctrl+End up to the first unused one (so going up) and save.

eric
29
luccio
 
Thank you very much. It's simple but it works :)
0