Find within Workbook.

G

Guest

Hello, I am trying to Find items in the whole workbook. I have multiple
workbooks in my Office 2003 SP1 (all updates) application. I would like to
have the default of Find Within Sheet - (Ctrl-F and in the Find and Replace
window, the drop down menu for Within: [Sheet, Workbook]).
I can initially select the Find Within Sheet and change it to Workbook, but
after I save (or not) the excel spreadsheet, I have to select Find Worksheet
again, as it has changed to the Sheet (as the default).

Is there a way to change the default from Find within Sheet to Find within
Workbook?

Thank you.

Matt
 
G

Guest

I don't know of a way that you can change this option. However, if you right
click on a sheet tab, you can click "Select All Sheets" and then do your find
(Ctrl+F). If you want to, you can create a macro to do this for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel shortcut options 0
find and replace, within workbook 1
Set the Find and Replace, Options, 'Within' default to Workbook 1
Excel Macro to un-mute Audio/speakers. 15
Merge Multiple workbook sheets into one workbook 0
How do I change the Excel "search" default to WORKBOOK & DATA? 5
Navigating worksheet tabs 5
In Excel how do I update cells in multiple sheets simultaneously? 1

Top