| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I free up the space occupied by empty rows?
I copied a large worksheet to numerous tabs in the same workbook. Then I
deleted most of the rows from each tab, but Excel still seems to think that there is data in all of the blank rows. Consequently, the spreadsheet occupies more bytes than it needs to and Lotus Notes won't let me email it to coworkers because of its size. Any ideas on how to free up the unused space? Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I free up the space occupied by empty rows?
Check out http://www.mvps.org/dmcritchie/excel/lastcell.htm or
http://www.beyondtechnology.com/tips019.shtml --JP On Sep 25, 10:59*am, davedadu wrote: I copied a large worksheet to numerous tabs in the same workbook. *Then I deleted most of the rows from each tab, but Excel still seems to think that there is data in all of the blank rows. Consequently, the spreadsheet occupies more bytes than it needs to and Lotus Notes won't let me email it to coworkers because of its size. *Any ideas on how to free up the unused space? Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I free up the space occupied by empty rows?
JP - thanks - I tried the second link that you provided and that did the trick!
"JP" wrote: Check out http://www.mvps.org/dmcritchie/excel/lastcell.htm or http://www.beyondtechnology.com/tips019.shtml --JP On Sep 25, 10:59 am, davedadu wrote: I copied a large worksheet to numerous tabs in the same workbook. Then I deleted most of the rows from each tab, but Excel still seems to think that there is data in all of the blank rows. Consequently, the spreadsheet occupies more bytes than it needs to and Lotus Notes won't let me email it to coworkers because of its size. Any ideas on how to free up the unused space? Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
| Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
| Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
| Getting Amount Free Disk Space On A Drive | Excel Discussion (Misc queries) | |||
| Free disk space chart in Excel | Charts and Charting in Excel | |||
Linear Mode
