Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I easily move to the next available cell in a column?
I'm using Excel 2007. After searching for a particular item number and not
finding it, I want to be able to go to the next available cell in a column without having to scroll through all my entries. Is there some sort of shortcut to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I easily move to the next available cell in a column?
It sounds like you have the Find dialog box open. If so, empty out the "Find
what" field, select "By Columns" in the "Search" drop down (you might have to click the "Options" button to expose it) and then click the "Find Next" button. Rick "Nonie" wrote in message ... I'm using Excel 2007. After searching for a particular item number and not finding it, I want to be able to go to the next available cell in a column without having to scroll through all my entries. Is there some sort of shortcut to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I easily move to the next available cell in a column?
Yes, that works. Thanks! Is there any way with less steps? A keyboard
shortcut perhaps? "Rick Rothstein (MVP - VB)" wrote: It sounds like you have the Find dialog box open. If so, empty out the "Find what" field, select "By Columns" in the "Search" drop down (you might have to click the "Options" button to expose it) and then click the "Find Next" button. Rick "Nonie" wrote in message ... I'm using Excel 2007. After searching for a particular item number and not finding it, I want to be able to go to the next available cell in a column without having to scroll through all my entries. Is there some sort of shortcut to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I easily move to the next available cell in a column?
You could put this macro in a Module (Insert/Module from the VBA menu
bar)... Sub FindEmptyCell() Columns(ActiveCell.Column).Find(What:="", LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByColumns).Select End Sub ....assign it a short-cut via the Options button on the Macros dialog box (Alt+F8, select FindEmptyCells, click the Options button and give it a short-cut keystroke). Then you would be able to push Ctrl+<keystroke to execute the code. Rick "Nonie" wrote in message ... Yes, that works. Thanks! Is there any way with less steps? A keyboard shortcut perhaps? "Rick Rothstein (MVP - VB)" wrote: It sounds like you have the Find dialog box open. If so, empty out the "Find what" field, select "By Columns" in the "Search" drop down (you might have to click the "Options" button to expose it) and then click the "Find Next" button. Rick "Nonie" wrote in message ... I'm using Excel 2007. After searching for a particular item number and not finding it, I want to be able to go to the next available cell in a column without having to scroll through all my entries. Is there some sort of shortcut to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easily change Move selection after Enter option | Excel Discussion (Misc queries) | |||
Shortcut to move to bottom (last) cell in a column | Excel Discussion (Misc queries) | |||
How do I easily format a column to convert input of 120307 to 12:. | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) |