Excel Can Find It!

Geez! I have a big file of customers with all their information including phone #’s & addresses .  I want to talk to Jim Smith but I can’t find him in my Excel spreadsheet. I also know that I have a lot of “Jim”s in my spreadsheet.  So let’s find the one I want. Go to cell A1 to make sure we start at the beginning of your data.

Go to the Edit menu and choose “Find”. Choose the “Find” tab in the next screen presented.

Enter Jim  in the “Find What:” Leave the defaults and check boxes as is (play with them later) and click “Find Next” at the bottom of the Find window… Voila! there’s the first “Jim″.   Maybe he’s not the Jim you’re looking for… click “Find Next” and there’s your next Jim!

Remember if you enter anything in the “Find What” field Excel will find it within any cell… it will find “Jim” in a cell containing “Jim anyone”.

My advice: when doing a Find  in any spreadsheet allways start in cell A1… it will give you the peace of mind knowing that Excel has looked everywhere.
Visit pasadmin.wordpress.com often… we add tips to help you Work Smart – Not Hard  every week!

If you’re frustrated with you Paper Work and need an experienced Paper Work expert to help you Call Peter

PAS Administrative Support Services

Peter 613-347-9893

pas-admin@sympatico.ca