ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Ctrl+End (https://www.excelbanter.com/new-users-excel/173284-ctrl-end.html)

l.kakubava

Ctrl+End
 

Hello everybody!

You all know Ctrl+End combo, in Word it goes to the end of document.
Now I want the same function in Excel, but it doesn't work.

Any ideas how to make it work?!




--
l.kakubava

Peo Sjoblom

Ctrl+End
 
Works for me, if you mean that it takes you too far, then see this:

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



--


Regards,


Peo Sjoblom



"l.kakubava" wrote in message
...

Hello everybody!

You all know Ctrl+End combo, in Word it goes to the end of document.
Now I want the same function in Excel, but it doesn't work.

Any ideas how to make it work?!




--
l.kakubava




ShaneDevenshire

Ctrl+End
 
Hi,

In Excel Ctrl+End moves you to the last active cell, which means the cell at
the intersection of the last row with something on it and the last column
with something in it. The last cell may be blank. The last row and/or
column may not contain any data, there might be comments in the cell or
formatting on the cells.

--
Cheers,
Shane Devenshire


"l.kakubava" wrote:


Hello everybody!

You all know Ctrl+End combo, in Word it goes to the end of document.
Now I want the same function in Excel, but it doesn't work.

Any ideas how to make it work?!




--
l.kakubava



All times are GMT +1. The time now is 11:06 AM.

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