| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving file without empty cells
Inevitably when you are working in Excel, Excel will think cells are filled
when in fact you have deleted the contents. If I do a End/Home, the cursor is on IA523. How do I save the file without including the rows and columns that are now blank? This became a problem when a macro opens the file and tries to move columns left and an error message came up that Excel could not move columns off the spreadsheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving file without empty cells
Excel always has all those rows and columns. You can't delete them.
But if ctrl-end takes you way past what you think should be the last used cell, take a look at Debra Dalgleish's site: http://www.contextures.com/xlfaqApp.html#Unused iashorty wrote: Inevitably when you are working in Excel, Excel will think cells are filled when in fact you have deleted the contents. If I do a End/Home, the cursor is on IA523. How do I save the file without including the rows and columns that are now blank? This became a problem when a macro opens the file and tries to move columns left and an error message came up that Excel could not move columns off the spreadsheet. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving file without empty cells
Thanks - great information
"Dave Peterson" wrote: Excel always has all those rows and columns. You can't delete them. But if ctrl-end takes you way past what you think should be the last used cell, take a look at Debra Dalgleish's site: http://www.contextures.com/xlfaqApp.html#Unused iashorty wrote: Inevitably when you are working in Excel, Excel will think cells are filled when in fact you have deleted the contents. If I do a End/Home, the cursor is on IA523. How do I save the file without including the rows and columns that are now blank? This became a problem when a macro opens the file and tries to move columns left and an error message came up that Excel could not move columns off the spreadsheet. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check certain cells for data before saving file | Excel Worksheet Functions | |||
| Cells widen after saving and reopening file | Excel Discussion (Misc queries) | |||
| How do I prevent saving an excel file if cells are blank? | Excel Worksheet Functions | |||
| Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
| Locking The Cells with Input At The Time of Saving The File | Excel Discussion (Misc queries) | |||
Hybrid Mode
