ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find/replace search field defaults (https://www.excelbanter.com/excel-discussion-misc-queries/56042-find-replace-search-field-defaults.html)

Kristin

Find/replace search field defaults
 
I have a workbook with multiple sheets. When I use Find/Replace, I generally
want to search across all fields. The default "Search within" is set at
"Sheet" so I have to change it each time I open the workbook. How can I set
this default to be "Workbook" so I don't have to change it each time?
Your help is greatly appreciated.
Thanks


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com