ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is the command that takes you to the last cell in a spreadshe (https://www.excelbanter.com/excel-discussion-misc-queries/157453-what-command-takes-you-last-cell-spreadshe.html)

Sam

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


PCLIVE

What is the command that takes you to the last cell in a spreadshe
 
Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...




Sam

What is the command that takes you to the last cell in a sprea
 
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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...





Dave Peterson

What is the command that takes you to the last cell in a sprea
 
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



Sam wrote:

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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...





--

Dave Peterson

PCLIVE

What is the command that takes you to the last cell in a sprea
 
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" wrote in message
...
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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...







Sam

What is the command that takes you to the last cell in a sprea
 
Thank You, That helps me entirely,

"Dave Peterson" wrote:

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



Sam wrote:

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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...





--

Dave Peterson


MartinW

What is the command that takes you to the last cell in a sprea
 
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


"Dave Peterson" wrote in message
...
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



Sam wrote:

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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...





--

Dave Peterson




Dana DeLouis

What is the command that takes you to the last cell in a sprea
 
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.

--
Dana DeLouis
Windows XP & Excel 2007


"Sam" wrote in message
...
Thank You, That helps me entirely,

"Dave Peterson" wrote:

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



Sam wrote:

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" wrote:

Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" wrote in message
...





--

Dave Peterson





All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com