Ctrl shift end

[Marion Knight-Dixon]

I use ctrl shift end to select a range of data which
works well most of the time. But I often import a large
spreadsheet that I have to cut and paste to reduce to a
much smaller size. My problem is that even if all the
surplus data is deleted when I use ctrl shift + end to
select the data range it still remembers the original
range and not the smaller reduced range.

I have tried clearing cells, deleting cells but to no
avail. The only way I have found to work around this is
to copy the revised spreadsheet to another sheet. Does
anyone have any suggestions? Many thanks

 

[Don Guillett]

Try touching the save button and see if that makes a difference.

 

[Debra Dalgleish]

There are some instructions here for resetting the used range:

http://www.contextures.com/xlfaqApp.html#Unused