💻 Software
Set Excel to search within entire workbook by default
Fresh5 days ago
Mar 15, 202627465 viewsConfidence Score0%
0%
Problem
In Microsoft Excel, when I search using CTRL+F, by default it only searches within the current worksheet. How can I set it to search within the entire workbook by default? I have . Is this even possible? Is it possible to set this for a specific workbook or worksheet? I'm okay with a registry edit …
Error Output
Office 2010
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Set Excel to search within entire workbook by default
Low Risk
You can do this with a Workbook_Open macro in the ThisWorkbook module, like so: This will set it for your session for the workbook you're in. To have this always be the default you need to create a Personal Macro Workbook. Note: Old line from origin…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix