123k views
3 votes
What is the keyboard shortcut to display a list of named ranges?

1) F1
2) F2
3) F3
4) F4

1 Answer

1 vote

Final answer:

In Microsoft Excel, F3 is the shortcut that displays a list of all the named ranges in the workbook, streamlining your workflow.

Step-by-step explanation:

The keyboard shortcut to display a list of named ranges in Microsoft Excel is F3. When you press F3 while working in a worksheet cell, Excel will show a dialog box listing all the named ranges in the workbook. This shortcut can save you time when you need to reference these ranges without having to navigate through different menus.

User Kris Van Der Mast
by
8.0k points