Excel Find in Multiple Worksheets
Excel Find in Multiple Worksheets
(OP)
Is there an easy way to find something on multiple worksheets without selecting each sheet and doing a ctrl-f? That's too much work when I have 100 worksheets.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Excel Find in Multiple Worksheets
|
RE: Excel Find in Multiple Worksheets
RE: Excel Find in Multiple Worksheets
RE: Excel Find in Multiple Worksheets
A word of caution be sure to unhighlight the multiple sheets before continuing doing work because any changes you do will be done on all sheets highlighted.
This multiple sheet selection is a way to change all the sheets print setups all at once.
RE: Excel Find in Multiple Worksheets
If that's all it's supposed to do then it did it but I'd like to know all the sheets where it's found.
RE: Excel Find in Multiple Worksheets
RE: Excel Find in Multiple Worksheets
I think it may be something to do with the cells selected on each sheet. Either select only one cell on each sheet or select all the cells.
I.e.
If you have the word 'and' in cell D10, if you select the range A1:C7 on the current sheet, it doesn't seem to find it.
To resolve this when you have grouped all the sheets, select a single cell, this will change each sheet selected.
Has this resolved the problem?
----------------------------------
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!
RE: Excel Find in Multiple Worksheets
Thanks for trying.
RE: Excel Find in Multiple Worksheets
RE: Excel Find in Multiple Worksheets
I don't have an options button.
RE: Excel Find in Multiple Worksheets
Try this...
http://support.microsoft.com/default.aspx?scid=kb;...
Microsoft Knowledge Base Article - 124105
Find Command Doesn't Work Across Worksheets in Group
This article was previously published under Q124105
RE: Excel Find in Multiple Worksheets