| |
Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
(303) 699-6868
Dawn@SoftwarePro.com
|
| |
Microsoft Excel Tip
Versions: All versions of Microsoft Excel>>More Microsoft Excel 2010 Tips & Tricks
>>More Microsoft Excel 2007 Tips & Tricks
>>More Microsoft Excel 2003 (and earlier) Tips & Tricks 
Find Shortcuts
A frequent question I hear on Excel is "How can I search for a word, name, or phrase in an entire workbook, not just a worksheet?" As with many other tricks and tips, this is easy but not obvious: - For Excel 2010 & 2007: pick Find from the Find & Select icon at the far right of the Home tab. In Excel 2003 & 2002: choose Edit > Find. Or, for any version: [CTRL] + F to Find.
- Enter the search word or phrase.
- Pick Options from the dialog box. Choose Workbook from the Within drop-down. Optionally, pick other choices such as Match entire cell contents.
- Now, select Find Next or, even better, choose Find All to preview all of the matches found. Just click on any of the results to move to the cell in your workbook.
>>More Tips & Tricks
| |
|
Tips, Tricks, Secrets
that you need to know now!
|
|
