Find Within Workbook

slipstream

Board Regular
Joined
Aug 24, 2005
Messages
61
Hi,

Is it possible to default excel 2010's search (ctrl+f) to workbook instead of worksheet.

I know various find comands can be preset (ie lookin/lookat) using vba and saving this in the xlstart folder, however i can't
seem to find anyway of setting the "within" command to workbook.

Any help would be appreciated.

Thanks
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Rajan_Verma

New Member
Joined
Jul 5, 2012
Messages
13
yes,

i am using 2010 and the find dialog box has an option to select where you need to find in withIn,

just change the withIn drop down to worbook from worksheets

Rajan
 

slipstream

Board Regular
Joined
Aug 24, 2005
Messages
61
i'm well aware of that, the problem is i use excel constantly during the day so do my work colleges and it's a pain having to constantly reset it, so i am looking for a more permanent solution.

Thanks anyways :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,814
Messages
5,598,243
Members
414,219
Latest member
ruchperformive

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top