What is the command that takes you to the last cell in a spreadshe

  • Thread starter Thread starter Guest
  • Start date Start date
Thankyou, I have tried it, and it takes you to the last cell that you have
inserted data into, and i need the command that takes you to the last cell in
the entire spreadsheet? Does such a thing exist?

PCLIVE said:
Ctrl+End should do what you want.

Regards,
Paul
Click to expand...
[/QUOTE]
 
Nothing built into excel.

But you could use ctrl-end to get to the bottom right corner of the usedrange.
Then end-downarrow, then end-rightarrow


Thankyou, I have tried it, and it takes you to the last cell that you have
inserted data into, and i need the command that takes you to the last cell in
the entire spreadsheet? Does such a thing exist?
Click to expand...
[/QUOTE]
 
Maybe a three stroke combination.

Holding Ctrl - press and release End and then Down-arrow
Release Ctrl

Then if you want to be in column A
Home

There may be another way, but that's one way.

Regards

--

Sam said:
Thankyou, I have tried it, and it takes you to the last cell that you have
inserted data into, and i need the command that takes you to the last cell
in
the entire spreadsheet? Does such a thing exist?
Click to expand...
[/QUOTE]
 
Thank You, That helps me entirely,

Dave Peterson said:
Nothing built into excel.

But you could use ctrl-end to get to the bottom right corner of the usedrange.
Then end-downarrow, then end-rightarrow
Click to expand...
 
Don't know if I'd call it a command but if you hold down
Ctrl then tap end, down arrow, right arrow and let go Ctrl
You will be at IV65536

HTH
Martin
 
Just another idea to add.
Ctrl+Home to take you to A1.
Ctrl+A to select all cells.
Shift+Tab to back up to the last cell.
 
Back
Top