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

Excel --> Word 4
Dealing with a Pivot Table (when I don't want to) 0
Scollbar re-size 2
How to modify and updte specific styles for specific paragraphs across the document 0
Cannot remove empty rows 8
Getting the graph style I want 4
How do I conceal the unused range from the scroll bar? 1
Look Up Formula With Veried Search Range 2

Top