| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large Excel file size
I am creating a number of small sheets using the top left hand corner of the
available space (A1 to AN45). However, if I hit [End] [Home] the cursor goes to the bottom right hand corner of the sheet, (cell IV65536), despite the cells from AN45 to IV65536 being empty. I frequently select all of the blank rows (and columns) and delete them. This results in a small file becoming significantly large. How do I correct this problem? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Large Excel file size
Have you save/close/reopen ?
See http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl "Simon G" wrote in message ... I am creating a number of small sheets using the top left hand corner of the available space (A1 to AN45). However, if I hit [End] [Home] the cursor goes to the bottom right hand corner of the sheet, (cell IV65536), despite the cells from AN45 to IV65536 being empty. I frequently select all of the blank rows (and columns) and delete them. This results in a small file becoming significantly large. How do I correct this problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubel with compression of a very large Excel file | Excel Discussion (Misc queries) | |||
| Reducing a size of the shared excel file | Excel Discussion (Misc queries) | |||
| excel chart file size | Charts and Charting in Excel | |||
| File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
| My excel file is too large (5 mb) when it shouldn't be, why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
