![]() |
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 |
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 |
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