| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clean/delete all cells outside of a range
We ran into one with a spreadsheet in which as far as could be told by any
way could be done seemed perfectly normal and functioned as should (other than speed) but this particular version took up some 60MB of disk storage. Keep in mind that the newer X-doc file format is a compound structure of files 'zipped' together as a single file. When these files become corrupt the culprit is not necessarily going to always be the xls portion of the file structure! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't filter/clean cells that contain #NAME? | Excel Programming | |||
| Macro to Clean Special characters for a Range | Excel Worksheet Functions | |||
| how can I delete cells containing text within a range of cells | Excel Discussion (Misc queries) | |||
| Is there a easy way to delete blank lines to clean up worksheets? | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
![GS[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
