Paste Name Dialog Box in Excel: How to Open It

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, press F3 to open the Paste Name dialog box. You can also open it from Formulas > Defined Names > Use in Formula > Paste Names. The dialog lets you insert a defined name into a cell or formula, or paste a list of workbook names and their references. At least one defined name must exist for the list to be useful.

What You’ll Need

  • A workbook open in the desktop version of Excel. The Paste Name dialog is a desktop feature; the same shortcut and ribbon options may not be available in Excel for the web.
  • At least one defined name in the workbook, such as a name assigned to a cell range. If you have not created one yet, the steps below explain how.
  • A target cell or formula location. If you plan to paste the complete list of names, choose a clear area of the worksheet with enough blank space below and to the right.

Step-by-Step

  1. Check that the workbook has a defined name. Go to Formulas > Defined Names > Name Manager and look for an entry in the list. A defined name is a label that refers to a cell, range, formula, or constant. For example, a name such as QuarterSales might refer to Sheet1!$B$2:$B$20. Close Name Manager when you have confirmed that a name exists. If there are no names, create one before continuing.
  2. Create a name if the workbook does not have one. Select the cell or range to name. Click the Name Box, the small box to the left of the formula bar that normally displays a cell address such as A1. Type a valid name, such as QuarterSales, and press Enter. Alternatively, select the range, choose Formulas > Defined Names > Define Name, enter the name and confirm the dialog. Names cannot contain spaces and should not look like a cell reference, so use an underscore if you need a separator, as in Quarter_Sales.
  3. Choose where the name should be inserted. Click the cell where you want the name to appear. To insert it into a formula, click the formula bar or start entering the formula in the cell first. For example, type an equals sign and the function name or opening formula text, then leave the insertion point where the name belongs. This makes it clear whether the inserted name should become cell content or part of a formula.
  4. Open the dialog with the keyboard shortcut. Press F3. On some laptops, the function row controls brightness or media functions by default, so press Fn+F3 instead. If you are editing a formula, Excel opens Paste Name at the current insertion point so you can choose a name to use in that formula.
  5. Or open it from the ribbon. Select the Formulas tab, find the Defined Names group, open Use in Formula, and choose Paste Names. This route is useful if your keyboard does not have a working F3 key or if you prefer to use the ribbon. Depending on the window size, the group or command may appear compact, but the command remains under the Formulas tab.
  6. Select the name you want. In the Paste Name dialog, click the desired entry in the list. If you have many names, use the list carefully: similarly named entries may refer to different ranges or have different scopes. The dialog is for inserting the name, not for changing what it refers to. If you are unsure about a name’s reference, close the dialog and inspect it in Name Manager first.
  7. Paste the selected name or the full list. Choose Paste to insert the selected name at the active cell or formula insertion point. If you want a worksheet inventory instead, click Paste List. Excel places the names and their references starting at the active cell, so use a blank area to avoid placing the list over existing information. After the name is inserted into a formula, finish the formula and press Enter to calculate it.

For example, suppose the workbook has a defined name called QuarterSales that refers to the sales range. To use it in a total, select a cell, type =SUM(, press F3, choose QuarterSales, paste the name, then type the closing parenthesis and press Enter. The resulting formula is =SUM(QuarterSales). The name must already refer to the intended cells; opening Paste Name does not create or repair the reference.

Common Mistakes

  • Expecting the dialog to create names. Paste Name only inserts names that are already defined. Use Name Manager, Define Name, or the Name Box to create a name first.
  • Pressing F3 while Excel is not the active application. The shortcut applies to the Excel desktop app. Click the workbook window and try again, or use the ribbon route.
  • Confusing a worksheet tab name with a defined name. A sheet called Sales is not automatically a defined name that appears in Paste Name. Check the entries in Name Manager.
  • Using Paste List over existing data. Paste List writes a list beginning at the selected cell. It is not just a preview. Move to an empty area or a new worksheet before using it.
  • Choosing a name with the wrong scope or reference. A name can apply to the whole workbook or only to one worksheet. Similarly named entries can therefore behave differently. Verify the scope and Refers to value in Name Manager when the result is unexpected.
  • Assuming the name is a text label only. A defined name points to something, such as a range or formula. Pasting the name into a formula uses that reference; typing it into a cell outside a formula may simply display the name as text.

Tips

  • Use F3 while building a formula. The shortcut can save typing and reduce spelling errors. Start the formula, position the cursor where the name belongs, and then choose it from the dialog.
  • Use Paste List as a quick name inventory. The output is useful when reviewing a workbook or documenting named ranges. Put the active cell in a blank area first, and check the resulting references against Name Manager if the workbook has complex scope settings.
  • Keep names descriptive and consistent. Names such as TaxRate or MonthlyCosts are easier to recognize than short labels such as x. Use underscores rather than spaces, and avoid names that resemble cell addresses.
  • Use Name Manager to investigate, not just to paste. It shows each name’s scope and what it refers to, and it provides controls to edit or delete entries. If a pasted name returns an unexpected value, inspect its reference there.
  • On a Mac, account for function-key settings. Excel for Mac also uses F3 for Paste Name in supported desktop versions, but macOS keyboard settings may assign a system action to the function key. Try Fn+F3 if pressing F3 alone does not reach Excel. The ribbon command is another option where it is available.

Troubleshooting

F3 does nothing or triggers a laptop control: Click inside the workbook, then try Fn+F3. If your keyboard has a function-lock setting, check whether it is enabled. You can also use Formulas > Defined Names > Use in Formula > Paste Names instead of relying on the key.

The Paste Name dialog opens, but the list is empty: The workbook may not contain any defined names. Open Formulas > Defined Names > Name Manager to confirm. If the list is empty, create a name for a range or formula and reopen Paste Name. A table name or sheet tab name should not be assumed to appear as a regular defined name in this dialog.

The dialog opens but the name will not go where expected: Check where the active cell or formula cursor is. If you want a formula, begin editing the formula before opening the dialog; otherwise, the name may be entered into the selected cell as ordinary cell content. If the formula has already been committed, select the cell and edit it in the formula bar, then place the cursor at the correct point.

The pasted name produces an error or the wrong result: The dialog inserts the name, but it does not validate the underlying reference for your purpose. Open Name Manager and inspect the Refers to entry and the name’s scope. If the name refers to a deleted range, the wrong sheet, or a different range with the same label, correct the definition there and retry.

Paste List replaces or obscures worksheet content: Undo immediately with Ctrl+Z if the paste was just made and no later action needs preserving. Otherwise, restore the affected cells from a saved copy or version history. Next time, select a blank area or add a worksheet before clicking Paste List. Be especially cautious if the selected cell is near existing data because the list can occupy multiple rows.

You are using Excel for the web: The browser version does not expose every desktop command in the same way. If you cannot find Paste Names or the F3 dialog, open the workbook in the desktop Excel app and use the shortcut or ribbon path there. Do not confuse a browser shortcut with an Excel command.

Frequently Asked Questions

What is the shortcut to open Paste Name in Excel?
In Excel for Microsoft 365 on Windows, press F3. On a laptop, Fn+F3 may be necessary if the function keys are assigned to hardware controls. On a Mac, try F3 or Fn+F3 depending on keyboard settings.

Can I open Paste Name without using the keyboard?
Yes. In desktop Excel, go to Formulas > Defined Names > Use in Formula > Paste Names. The command opens the same dialog, so you can select a name and paste it.

Why is Paste Name unavailable or empty?
There may be no defined names in the workbook, or you may be using a version of Excel that does not provide the same desktop dialog. Check Name Manager first. If you use Excel for the web, try opening the file in desktop Excel.

Does Paste Name create a name for my selected cells?
No. It inserts an existing name into a cell or formula. To create a name, select the cells and use the Name Box or choose Formulas > Defined Names > Define Name.

What does Paste List do?
It writes a list of defined names and their references into the worksheet, starting at the active cell. Select a blank area first so the output does not overlap existing content.

Can I use a pasted name in a formula?
Yes. Start or edit a formula, place the cursor where the name should go, press F3, select the name, and paste it. Complete the rest of the formula and press Enter.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.