what should i do if i don't want to see empty rows ?

D

Denish

In my excel sheet, i see 65536 rows and i am doing my work only among 200 to
250 rows. size of my scrollbar becomes too small so that i can not use
scrollbar for 10 to 15 rows. i want scrollbar sized according to used rows.
 
D

Dave

Hi Denish
Select all the rows in the worksheet after your data.
Then Right-click, Delete.
Save the workbook, and close.
Open the workbook.
This should restore your scroll-bars.

Regards - Dave
 
D

Denish

Done.
Thanks Dave.

Dave said:
Hi Denish
Select all the rows in the worksheet after your data.
Then Right-click, Delete.
Save the workbook, and close.
Open the workbook.
This should restore your scroll-bars.

Regards - Dave
Click to expand...
 

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

How do I conceal the unused range from the scroll bar? 1
Cannot remove empty rows 8
I just want to have my columns formatted without actually formatting 6000 rows. 18
Empty Cells Causing Huge File Size 2
Problem with Huge Empty Cells 2
setting the area to show up in preview 3
My rows keep "unhiding" when I do not want them to 6
I can't see Grand total rows even though the option's switched on 2

Top