Is there a shortcut for Excel to open the find dialog with search within workbook selected?
If not, is there a way to bind this functionality, say overwriting the format cell shortcut
I misread the initial question as asking for Find in workbook, instead of the shortcut. My proposed shortcut is just below these steps.
Press Ctrl+F to open the Find window.
Then click on Options to expand advanced settings.
In "Within" dropdown, select Workbook.
Now your search will be applied to the workbook instead of current sheet.
This selection will persist until you close Excel.
This is not really a shortcut, but can work using only keyboard.
These are the exact shortcuts for the same steps mentioned earlier in the post.