| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hundreds of Blank rowas below my content-filled rows
Hey y'all,
Somehow my spreadsheet, which contains about 350 rows of populated data, includes rows all the way down to 2500. This makes the scroll bar very small, and it's just plain annoying. I've tried deleting, hiding, setting print area, doing the edit-go to-special-blank-delete thing, and nothing works. This doesn't affect data quality or even print range, but it makes the scrolling hard to do, and it's bugging me. How do I fix this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hundreds of Blank rowas below my content-filled rows
Debra Dalgleish shares a few ways he
http://contextures.com/xlfaqApp.html#Unused Laura wrote: Hey y'all, Somehow my spreadsheet, which contains about 350 rows of populated data, includes rows all the way down to 2500. This makes the scroll bar very small, and it's just plain annoying. I've tried deleting, hiding, setting print area, doing the edit-go to-special-blank-delete thing, and nothing works. This doesn't affect data quality or even print range, but it makes the scrolling hard to do, and it's bugging me. How do I fix this? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hundreds of Blank rowas below my content-filled rows
Select and Delete the undesired Rows, then Save the file to reset the
"last cell". Laura wrote: Hey y'all, Somehow my spreadsheet, which contains about 350 rows of populated data, includes rows all the way down to 2500. This makes the scroll bar very small, and it's just plain annoying. I've tried deleting, hiding, setting print area, doing the edit-go to-special-blank-delete thing, and nothing works. This doesn't affect data quality or even print range, but it makes the scrolling hard to do, and it's bugging me. How do I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Omitting blank cells until filled in? | Excel Worksheet Functions | |||
| How can I remove multiple (hundreds) of blank rows in one step? | Excel Discussion (Misc queries) | |||
| Can i reduce my file that's 29 MB but filled with blank cells? | Excel Discussion (Misc queries) | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Linear Mode
