View original (French)

Reduce the size of the sliders in EXCEL

Solved
JNICO Posted messages 8 Status Member -  
 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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. luccio
       
      Thank you very much. It's simple but it works :)
      0