0

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 CTRL+SHIFT+F?

  • 1
    Ctrl+F ? Why this doesn't work for you? – Vylix Jul 6 '17 at 14:29
  • @Vylix Ctrl+F does a find in the current sheet. I would like the workbook. – kjhf Jul 6 '17 at 16:13
3

I misread the initial question as asking for Find in workbook, instead of the shortcut. My proposed shortcut is just below these steps.

  1. Press Ctrl+F to open the Find window.

  2. Then click on Options to expand advanced settings.

  3. 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.

  1. Ctrl+F
  2. Alt+T
  3. Alt+H, , Enter
  4. Alt+N then start typing

These are the exact shortcuts for the same steps mentioned earlier in the post.

Find in workbook

  • Hi Vylix, thanks for your answer, I already knew this is how to search within a wokbook but I would like a shortcut for this. It's annoying to have to select Workbook each time from the dropdown. – kjhf Jul 6 '17 at 16:30
  • 1
    @kjhf I added a workaround, which can be used as shortcut if used in quick succession - if you got used to it. – Vylix Jul 6 '17 at 17:05
  • 1
    Add an Alt + N to the end in order to return to the find box and that's a nice compromise :) – kjhf Jul 7 '17 at 9:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.