shortcut for end of sheet

[peadar]

I am trying to go to the end of a sheet with approximately 300 rows.
But pressing CTRL + END goes to row 917 and col I.
I have tried clearing the print area, which I didn't think would help
and didn't.
I tried highlighting the rows from 300 to 917 and clearing an
deleting, but still CTRL + END goes to to row 917.
Is CTRL + END the correct short cut for the end of the sheet?
Is there a way to see why it goes to row 917 and to clear/delete tha
so CTRL + END goes to the end at row 300?
Thank you, Pete

 

[Norman Harker]

Hi Peadar!

See:

Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Peter
have a look at
http://www.contextures.com/xlfaqApp.html#Unused

 

[Lady Layla]

Go to last cell, Select area from last cell to last actual cell, right click ,
delete, entire row. Do same for columns, save, close file, reopen file


: I am trying to go to the end of a sheet with approximately 300 rows.
: But pressing CTRL + END goes to row 917 and col I.
: I have tried clearing the print area, which I didn't think would help,
: and didn't.
: I tried highlighting the rows from 300 to 917 and clearing and
: deleting, but still CTRL + END goes to to row 917.
: Is CTRL + END the correct short cut for the end of the sheet?
: Is there a way to see why it goes to row 917 and to clear/delete that
: so CTRL + END goes to the end at row 300?
: Thank you, Peter
:
:
: ---
: Message posted
:

 

[RagDyeR]

Select the *entire* row past (below) what you wish to be the end of your
data.
Then do,
<Ctrl> <Shift> <DownArrow>
To select all the rows down to 65536.
If you don't see row 65536, repeat until you do.
Then, while all are *still* selected, right click in the selection and
choose <Delete>.

You can do the same thing for columns, using the right arrow, and going out
to column IV.

Now "Save" - and try the <Ctrl> <End> once more.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to go to the end of a sheet with approximately 300 rows.
But pressing CTRL + END goes to row 917 and col I.
I have tried clearing the print area, which I didn't think would help,
and didn't.
I tried highlighting the rows from 300 to 917 and clearing and
deleting, but still CTRL + END goes to to row 917.
Is CTRL + END the correct short cut for the end of the sheet?
Is there a way to see why it goes to row 917 and to clear/delete that
so CTRL + END goes to the end at row 300?
Thank you, Peter