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
 
Back
Top