Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
latest entry | Excel Worksheet Functions | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |