How do I search for information within my workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if there possibly a search option in which you can look
up information within a workbook. For example, I am looking for a purchase
order number within a worksheet that I update everyday. There is tons of
information on this spreadsheet, but I want to know if there a faster way to
retrieve this information. (instead of trying to go line by line through the
spreadsheet.)
 
Pres the 'ctrl' and 'f' keys together. This will give you a dialogue box.
Type the PO number you are looking for in the box and hit 'OK'. You can
continue to hit 'Find Next' in the dialogue box until you found the right
entry.

Good Luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving information between worksheets 1
hidden sheets 2
Linking multiple worksheets in one workbook 2
Trace links between worksheets within one workbook 4
How do I make the default Find>>Within>>Workbook in Excel? 4
Connecting a master sheet to other sheets within the same workbook 3
How do I change the Excel "search" default to WORKBOOK & DATA? 5
moving information within a workbook 1

Back
Top