Sroll Box within Scroll Bar

G

Guest

If I highlight a range in a work sheet to have row height increased and say range is from A1-A400. The scroll box within the scroll bar resizes for that range. If my spreadsheet however turns out to be only 50 rows(after entering data) not 400 the bar will still be sized to go from row 1 at the top to Row 400 at bottom(It can obvously go past that but the scroll box is sized for 400). I would like it to go back to its to size for the actual size of the data in the spreadsheet. I have tried to delete the rows from 50-400 but it has no effect. Any help would be appreciated as this is annoying problem.
 
G

Gord Dibben

Shawn

After Edit>Delete>Entire Row you must save, close and re-open the workbook to
see changes to the size.

Gord Dibben XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scroll Bar question 2
Formatting the vertical scroll bar 1
SCROLL BAR ISSUE 4
Excel's scroll bar 5
Need help on formatting row height 1
How do I conceal the unused range from the scroll bar? 1
Excel 2003 vertical scroll bar 4
Side Scroll Bar Pagination Problem 9

Top