Excel Quick Access Toolbar: Add Paste Values Easily

How-to basics · Updated November 19, 2026

To add Paste Values to the Quick Access Toolbar in Excel for Microsoft 365 on Windows, open the toolbar’s Customize Quick Access Toolbar menu, choose More Commands, set Choose commands from to All Commands, select Paste Values, click Add, then click OK. After copying cells, click the new toolbar button to paste their results without copying their formulas or formatting.

What Paste Values does

Excel normally copies a cell’s contents, formula, formatting, and other properties together. Paste Values takes a narrower approach: it puts the copied cell’s current value into the destination, rather than transferring the formula that produced it. It also does not bring over the copied cell’s formatting. The destination’s existing formatting remains in place.

For example, suppose B2 contains the formula =A2*1.1 and currently displays 55. If you copy B2 and use Paste Values in another cell, Excel puts 55 there, not the formula referencing A2. If A2 later changes, the pasted 55 does not recalculate. This is useful when you want to keep a result while removing its dependence on source cells.

Values can be text, numbers, dates, logical results such as TRUE or FALSE, or an error result. A date is stored as a number in Excel, so pasting its value into a cell with General formatting can show a serial number instead of a date. If the date appearance matters, format the destination separately or choose a paste option that includes number formatting.

Add Paste Values to the Quick Access Toolbar

The Quick Access Toolbar, or QAT, is a small customizable set of commands available independently of the selected ribbon tab. Excel commonly places it near the upper-left corner of the window, though its position can be changed. To add the command on Windows:

  1. Click the small Customize Quick Access Toolbar arrow at the end of the toolbar. If the toolbar is below the ribbon, look for the arrow there.
  2. Choose More Commands to open Excel Options.
  3. In Choose commands from, select All Commands. The default list may not show Paste Values.
  4. Scroll to Paste Values, select it, and click Add. Check that it appears in the list on the right.
  5. Click OK to close the options window.

The Paste Values command should now appear as a button on the QAT. Hover over it to read its ScreenTip if several icons look similar. In the command list, make sure you select Paste Values, not Paste Special or one of the options that also carries formatting.

You can change the order of QAT buttons in the same options window by selecting a command in the right-hand list and using the move-up or move-down controls. To remove the button, select it in that list and click Remove. Depending on your Excel setup, the customization dialog may let you apply changes to all documents or to the current workbook; check that choice if the button appears only in one file.

Use the button to paste values

The button acts on the current copy operation, so copy the source before you click it. Select the cells, press Ctrl+C, select the destination, and click Paste Values on the QAT. Excel pastes the copied results into the selected destination. The QAT button is especially handy when the Paste Values option is not already visible on the ribbon.

For a simple example, copy a column of formula-generated totals and paste the results into a new column using the button. The new column contains fixed numbers rather than formulas. You can then send the workbook to someone who needs the figures but not the calculations, or remove the original calculation cells without breaking those pasted figures.

For a multi-cell range, copy the entire source range and select the top-left destination cell before clicking the button. Excel fills the corresponding destination area. If the destination selection has a different shape or size, Excel may report that the copied area and paste area do not match. Selecting one destination cell is a reliable way to avoid an accidental mismatch.

The command does not calculate or convert a formula into a different kind of result. It copies the result available at the time of pasting. If a workbook uses manual calculation and a formula has not recalculated, the displayed or stored result may not reflect the latest input. Recalculate the workbook first if you need current results.

Choose the right paste option

Paste Values is one member of Excel’s family of paste choices. The best choice depends on what must carry over. The options can appear in the Home tab’s Paste menu or in the Paste Special dialog, and their icons may vary slightly across builds.

  • Paste Values: transfers the copied results, not the source formulas or source formatting. The destination’s formatting is retained.
  • Values and Number Formatting: transfers the results and number formats, such as currency, percentage, or date display. It does not copy all other source formatting.
  • Values and Source Formatting: transfers results along with source formatting. Use it when the pasted cells should look like the originals as well as contain fixed results.
  • Paste Formulas: transfers formulas rather than replacing them with their current results. Relative references may adjust for the destination location.
  • Paste Special: opens a dialog with more control over what is transferred, such as formulas, values, formats, or operations.

A common misconception is that Paste Values makes the pasted cells look exactly like the copied cells. It does not: that is why the separate choices involving number formatting or source formatting exist. If a result such as 0.25 must display as 25%, use Values and Number Formatting, or apply percentage formatting after using Paste Values.

Other ways to paste values

If you do not want another QAT button, the Home tab provides paste choices. On Windows, copy the cells, select the destination, then choose Home > Paste and select the values-only option in the menu. The exact icon presentation can differ, so use the ScreenTip or command label rather than relying only on the picture.

Another option is Paste Special. On Windows, copy the cells, select the destination, press Ctrl+Alt+V to open the Paste Special dialog, select Values, and press Enter. In versions where the dialog accepts its letter key, pressing V selects Values; confirm the selection shown before pressing Enter. This method is useful when you need to choose another special paste behavior in the same dialog.

On a Mac, the ribbon and customization screens differ from Windows. Depending on the Excel build, Quick Access Toolbar settings are managed through Excel > Settings or Preferences > Ribbon & Toolbar, where you can select the Quick Access Toolbar and add commands. Paste Special is commonly opened with Control+Command+V. Check the labels in the installed version because menus and shortcuts can vary by release. Excel for the web does not offer the same desktop QAT customization; use the available Home > Paste options instead.

Common problems and fixes

If Paste Values is missing after you customize the toolbar, reopen More Commands and check that the command was added to the right-hand list before you clicked OK. Also check whether you customized the current workbook rather than all documents. The toolbar may be hidden or positioned below the ribbon, so inspect both locations and the ribbon display settings.

If clicking the button does nothing useful, make sure a range has been copied and that Excel is still in copy mode. Selecting another range and pressing Esc can cancel the copy outline; copy again before using the QAT button. Also make sure you are using the Paste Values icon rather than a neighboring Paste Special or formatting command.

If a pasted date appears as a number, the value may be correct but the destination format is General. Apply a date format from Home > Number Format, or repeat the paste using Values and Number Formatting. Similarly, a decimal may display without a percent sign or currency symbol because values-only paste does not bring the source’s number format.

If formulas appear instead of fixed results, the regular Paste command may have been used. Undo immediately with Ctrl+Z if appropriate, then copy the source again and choose Paste Values. For a large range, confirm that the destination begins in the intended cell; a values-only paste can overwrite existing data just like an ordinary paste.

When values-only paste is useful

Use the command when a workbook has reached a handoff point: calculations are complete, and the recipient needs stable figures rather than live links to source cells. It can also help preserve a snapshot of a report, replace slow formulas in a finished output area, or prevent a copied formula from changing its references in a new location.

It is not always the right way to share a workbook. Pasted results no longer update when assumptions or source data change, and formula logic is not retained in those cells. Keep a formula-based working copy when future recalculation or auditability matters. A practical workflow is to retain the original calculation sheet, then paste values into a separate presentation or export sheet.

Be careful with formulas that return text or errors: Paste Values freezes that result too. If a source formula currently displays #N/A, that error is what gets pasted. Resolve or intentionally retain such results before creating a fixed-value copy. For confidential data, remember that converting formulas to values is not a privacy feature; the displayed data itself remains in the workbook.

Frequently Asked Questions

Can I add Paste Values to Excel’s Quick Access Toolbar?
Yes. Open Customize Quick Access Toolbar > More Commands, choose All Commands, select Paste Values, click Add, and click OK. These steps apply to desktop Excel for Microsoft 365 on Windows.

Does Paste Values remove formatting?
It does not copy the source formatting. The destination keeps its existing formatting. If you want the result and its number format, choose Values and Number Formatting; if you want broader source formatting too, use Values and Source Formatting.

Does Paste Values keep formulas linked to the source?
No. It pastes the formula’s current result as a fixed value. Later changes to the formula’s inputs do not update that pasted result.

What is the keyboard shortcut for Paste Values in Excel?
There is no single universal dedicated Windows shortcut for the QAT command. A dependable route is Ctrl+C, select the destination, Ctrl+Alt+V, choose Values in Paste Special, and press Enter. On Mac, Control+Command+V commonly opens Paste Special.

Why did my pasted date turn into a number?
Dates are stored as numbers, and Paste Values does not bring over the source’s number format. Apply a date format to the destination or use Values and Number Formatting.

Can I use the same customizable toolbar in Excel for the web?
Excel for the web does not provide the same desktop Quick Access Toolbar customization. Use the paste choices available on its Home tab, and check the menu labels in your browser version.

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.