Excel Tip of the Day
Find all occurrences of a word at once (Excel 2002)
One of the great timesavers introduced in Excel 2002 is the ability to quickly locate and navigate to all instances of a particular character string. To use this new functionality, choose Edit | Find from the menu bar or press [Ctrl]F to launch the Find And Replace dialog box. Then, enter the text you want to find in the Find What text box. Finally, click the Find All button. The dialog box expands to show a list of all the found matches. Clicking on the items in the list selects the relevant cell, which is especially handy when working with large worksheets. Another plus is that you aren't just limited to finding occurrences in the current worksheet -- you can search an entire workbook. To do so, click the Options button on the Find And Replace dialog box. Then, choose Workbook from the Within dropdown list and click Find All.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.