| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what should i do if i don't want to see empty rows ?
You're welcome.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
Linear Mode
