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

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.

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

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

"Denish" wrote:

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.

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

Done.
Thanks Dave.

"Dave" wrote:

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

"Denish" wrote:

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.

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

You're welcome.