Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually delete cells not being used at ends of workbook
My excel workbook is too large and I think the problem is that I copied
formats to the end of the sheet. When I hit "Ctrl + End" it goes to the end of the sheet even though I have deleted the cells and the rows manually. Any help is appreciated? I have gone to the site http://www.contextures.com/xlfaqApp.html#Unused and closed and reopened my workbook but the cells are still there. Any additional help would be appreciated? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually delete cells not being used at ends of workbook
Determine what is the lower right corner of your spreadsheet, then
delete all the columns to the right of that and all the rows below it. When you save the workbook, CTRL-END brings you to your desired lower right corner. Merely clearing the contents of those cells won't work: you must delete them. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually delete cells not being used at ends of workbook
I have deleted them. I have deleted all cells that are not being used but it
doesn't seem to work for me. "Dave O" wrote: Determine what is the lower right corner of your spreadsheet, then delete all the columns to the right of that and all the rows below it. When you save the workbook, CTRL-END brings you to your desired lower right corner. Merely clearing the contents of those cells won't work: you must delete them. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually delete cells not being used at ends of workbook
What finally worked for me is to do a save-as to itself. You don't even have
to close the file. "Woody13" wrote: I have deleted them. I have deleted all cells that are not being used but it doesn't seem to work for me. "Dave O" wrote: Determine what is the lower right corner of your spreadsheet, then delete all the columns to the right of that and all the rows below it. When you save the workbook, CTRL-END brings you to your desired lower right corner. Merely clearing the contents of those cells won't work: you must delete them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
how do I delete a worksheet from my workbook | New Users to Excel | |||
Cells to link to "current workbook" | Excel Discussion (Misc queries) | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) |