Home |
Search |
Today's Posts |
#1
|
|||
|
|||
navigate in Excel worksheet without scrolling
Can you navigate in an Excel worksheet without scrolling? My datafile is very
long and I'd like to go from last names starting with A to names starting M. |
#2
|
|||
|
|||
Hi
You could select the whole column and do a Find (Ctrl F) for M* with 'Find Entire Cells Only' selected. -- Andy. "johnson.82" wrote in message ... Can you navigate in an Excel worksheet without scrolling? My datafile is very long and I'd like to go from last names starting with A to names starting M. |
#3
|
|||
|
|||
One quick way to get where you want is to:
1)Select the column with the names. 2)Press [Ctrl]+F. (or EditFind) 3)Enter the beginning of what you're looking for followed by and asterisk: Example: Names beginning with G would be entered G* 4)Click the box to "Match entire contents of cell" 5)Click OK Excel will bring you to the 1st name beginning with G. I hope that helps. Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions |