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

S

Sam

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]
 
D

Dave Peterson

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]
 
P

PCLIVE

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]
 
S

Sam

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...
 
M

MartinW

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
 
D

Dana DeLouis

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.
 
Top