ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to I get to the last entry quickly (https://www.excelbanter.com/excel-worksheet-functions/79076-how-i-get-last-entry-quickly.html)

tweacle

How to I get to the last entry quickly
 

I have a database with approx 2000 entries. Im trying to get to the last
entry I put in quickly. Ive tried using ctrl + end and it takes me
straight to the end of the workbook and not the last entry.

Anyone got any other ideas how I can overcome this and go to the last
entry and not the end of the workbook.


--
tweacle

Peo Sjoblom

How to I get to the last entry quickly
 
Use this method

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

then use ctrl + end


--

Regards,

Peo Sjoblom

"tweacle" wrote in message
...

I have a database with approx 2000 entries. Im trying to get to the last
entry I put in quickly. Ive tried using ctrl + end and it takes me
straight to the end of the workbook and not the last entry.

Anyone got any other ideas how I can overcome this and go to the last
entry and not the end of the workbook.


--
tweacle




Sloth

How to I get to the last entry quickly
 
ctrl + †“ (down arrow)

this will work unless you have blank cells, then it will take you to the
cell before the blank cell.

"tweacle" wrote:


I have a database with approx 2000 entries. Im trying to get to the last
entry I put in quickly. Ive tried using ctrl + end and it takes me
straight to the end of the workbook and not the last entry.

Anyone got any other ideas how I can overcome this and go to the last
entry and not the end of the workbook.


--
tweacle



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

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