Cells in range a1:m137 contain data.

But, when I use 'Go To Special' and click 'Last Cell', the cursor goes to a cell outside of range a1:m137.

How do I clear/delete all cells outside of range a1:m137?

Cells in range a1:m137 contain data.

But, when I use 'Go To Special' and click 'Last Cell', the cursor goes to a
cell outside of range a1:m137.

How do I clear/delete all cells outside of range a1:m137?

Select entire cols and/or rows, Delete both, then Save.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

That didn't work so I copied range a1:m137 and pasted it into a new spreadsheet.

Now, in the new spreadsheet, when I use 'Go To Special' and click 'Last Cell', the cursor goes to m137.

That didn't work so I copied range a1:m137 and pasted it into a new
spreadsheet.

Now, in the new spreadsheet, when I use 'Go To Special' and click 'Last
Cell', the cursor goes to m137.

You only do cols or rows at a time outside the data area! So if Ctrl+End goes
to p150 then...

Select O:P and Delete
Select 138:150 and Delete
Save the file

This works EVERY TIME unless you do something wrong.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I selected all columns to the right of m1 and deleted all of those columns.
I then selected all rows below a137 and deleted all of those rows.

I then used 'Go to Special' and clicked "Last cell" but the cursor still went to cells outside of a1.m137.

I selected all columns to the right of m1 and deleted all of those columns.
I then selected all rows below a137 and deleted all of those rows.

I then used 'Go to Special' and clicked "Last cell" but the cursor still went
to cells outside of a1.m137.

You don't say you Saved the file after deleting; -*the most important part of
the process!*

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

After I deleted the rows and columns in the original spreadsheet, I saved the file.

I then opened that file again.

Then I used the "Go to Special" and clicked "Last Cell" and the cursor went to a cell outside of the range.

After I deleted the rows and columns in the original spreadsheet, I saved the
file.

I then opened that file again.

Then I used the "Go to Special" and clicked "Last Cell" and the cursor went
to a cell outside of the range.

Ok, this has been the process I've been using since Excel5.0 and it hasn't been
replaced yet with some other process! I use Ctrl+End (keyboard equivalent to
'Go to Special:Last Cell') It works as I'm describing it EVERY TIME! Go ahead
and try it; -duplicate the scenario and see what happens...

Not saying the behavior you got is not possible since Excel (MS Office in
general) has had a tendancy to 'misbehave' more than ever with the newer
releases. Just try the exercise for your own benefit so you can see *how it
should behave* normally.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

After I deleted the rows and columns in the original spreadsheet, I saved the file.

I then opened that saved file.

Then I used the "Go to Special" and clicked "Last Cell" and the cursor went to a cell outside of the range.

I resolved the problem by copying only the range, pasting it into a new spreadsheet and saving the new file.

I then deleted the original file so I can't "duplicate the scenario" and "try the exercise for your own benefit"

I resolved the problem by copying only the range, pasting it into a new
spreadsheet and saving the new file.

I then deleted the original file so I can't "duplicate the scenario" and "try
the exercise for your own benefit"

Huh!
You can enter some value outside your table, ClearContents, then Ctrl+End to
see where the LastCell is located. Just delete the rows/cols necessary to
eliminate the last cell, save, then Ctrl+End to see that the lower right corner
of your table is now the LastCell.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I resolved the problem by copying only the range, pasting it into a new
spreadsheet and saving the new file.

You mean you 'got around' the problem this way. Seems an awefully inefficient
approach to me!<g

I then deleted the original file so I can't "duplicate the scenario" and
"try the exercise for your own benefit"

Huh!
You can enter some value outside your table, ClearContents, then Ctrl+End to
see where the LastCell is located. Just delete the rows/cols necessary to
eliminate the last cell, save, then Ctrl+End to see that the lower right
corner of your table is now the LastCell.

If you just use 1 cell then you only have to delete that 1 cell.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On 2/5/2018 12:02 PM, GS wrote:
I resolved the problem by copying only the range, pasting it into a
new spreadsheet and saving the new file.

You mean you 'got around' the problem this way. Seems an awefully
inefficient approach to me!<g

I then deleted the original file so I can't "duplicate the scenario"
and "try the exercise for your own benefit"

Huh!
You can enter some value outside your table, ClearContents, then
Ctrl+End to see where the LastCell is located. Just delete the
rows/cols necessary to eliminate the last cell, save, then Ctrl+End to
see that the lower right corner of your table is now the LastCell.

If you just use 1 cell then you only have to delete that 1 cell.

Those exercise work "most of the time" but I've found it's possible to
corrupt Excel where stuff like that is "just simply broke" with some
sheets. This seems more and more prevalent with newer release(s).

Most of the time things otherwise function normally.

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.

I ran every MS and third party diagnostic on it I could find and none
could find anything to report. Like GARYWC here, the only way I could
find to resolve it was to copy values to a new sheet; pasting cell
content would reproduce the symptom so whatever it was was some huge
memory blob that simply couldn't get rid of any other way I could find.

--