Solved

Excel 2007 - multiple Find boxes

Posted on 2011-03-17
5
157 Views
Last Modified: 2012-05-11
Hi,

Please offer suggestions on how I can have more than one 'Find' dialogue box open in Excel 2007.

Thank you.
0
Comment
Question by:tahirih
  • 3
5 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35161837
Why?

Kevin
0
 
LVL 50

Expert Comment

by:teylyn
ID: 35161840
Hello,

I don't think you can open more than one Find box with native Excel. You'd have to create something with VBA instead.

cheers, teylyn
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 35161846
Do you know that Excel keeps a short list of previous search values which you can access from the Find dialog by clicking on the dropdown arrow control on the "Find what" field?

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35161867
Only one Find dialog can be open at once.

Kevin
0
 

Author Closing Comment

by:tahirih
ID: 35161869
Thank you.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now