Written by Allen Wyatt (last updated April 25, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
You already know how to find information in an Excel worksheet by using the searching features built into the program. Using the Find tool (press Ctrl+F) you can search for just about anything in your worksheet. I find myself using Find quite often in the course of editing a worksheet, particularly if the worksheet is quite large.
There is one thing about Find that bothers me, however. I hate having the Find and Replace dialog box block part of my worksheet as I am stepping through occurrences of a search string. Clicking on Find Next works great, but that bothersome dialog box is still blocking my view.
To overcome this, I generally do the following when I am searching for something:
This procedure works the same as clicking Find Next repeatedly, and it is just as fast, but it gets rid of the annoying Find dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2117) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: A Fast Find-Next.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Want to convert the text in a cell so that it wraps after every word? You could edit the cell and press Alt+Enter after ...
Discover MoreIf you need to look at different parts of the same worksheet at the same time, the answer is to create windows for your ...
Discover MoreLimiting what can be entered in a cell can be an important part of developing a worksheet that other people use. Here's a ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-04-25 10:41:00
alex
I tried with F4 alone and it also worked, thanks, Alex
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments