If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
find
I am trying to set up a worksheet at work that lists case numbers in the
following format ab12345 how do i do a search for a specific case and I want to search the entire workbook. |
#2
|
|||
|
|||
find
hi
click Ctrl+F in the find box, enter ab12345 click the options button-lower left in the within combo box, selec workbook click find all a box will appear at the bottom showing all finds within the workbook. if only 1, excel will goto it. if more than one, excel will select the first instance. if more, click on the line in the box to go to it. regards FSt1 "cmkwolf" wrote: I am trying to set up a worksheet at work that lists case numbers in the following format ab12345 how do i do a search for a specific case and I want to search the entire workbook. |
Thread Tools | |
Display Modes | |
|
|