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?

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.

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.

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.