| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cursor movement to last cell with same number
Works like a charm! Thanks, guys!
"Gord Dibben" wrote: Find and Select from Home Tab In the Find What dialog box enter 4097 Then hold SHIFT key and hit "Find Next" Gord Dibben MS Excel MVP On Tue, 6 Oct 2009 16:02:03 -0700, Steven wrote: I'm sorry, Bob, but I don't follow. I'm using Excel 2007, and can access Find in two different ways: 1. CTRL-F. I've tried holding down the Shift while typing CTRL-F with no luck. 2. Click on Find and Select from the main page. I've clicked on that, and held down the Shift while clicking on Find, also with no luck. What am I doing wrong? "Bob Umlas" wrote: Edit/Find, 4097, hold the SHIFT key down and press Find. "Steven" wrote in message ... I have some spreadsheets and several columns within them have only six or seven possible values. Currently I scroll through these columns manually to find the breaks between numbers. Is there a cursor control to move the cursor to the last cell to have the same number as in the cell the cursor currently resides on? For example: 4097 4097 4097 4097 4098 4098 4098 If I'm currently on a 4097 cell, I would want to move down to the last 4097-valued cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cursor movement | New Users to Excel | |||
| How do I disable the cursor movement after hitting enter in a cell | Excel Discussion (Misc queries) | |||
| Cursor Movement | Excel Discussion (Misc queries) | |||
| cursor movement | Excel Worksheet Functions | |||
| Cursor movement | Excel Worksheet Functions | |||
Hybrid Mode
