How to Add Paste Values and Formatting to Excel Quick Access Toolbar
Question details
The user wants to streamline the process of pasting values and formatting without navigating through the standard Paste Special dialog box menus.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Improving daily spreadsheet workflow by making frequently used paste commands easier and faster to access from the main interface.
- Observed behavior
- Currently, pasting values and formatting requires several clicks through the Paste Special menu, which is inefficient for repetitive data entry tasks.
Ensure you have Microsoft Excel open and familiarize yourself with the Quick Access Toolbar, which is typically located at the very top-left corner of the application window.
Add the Command to the Quick Access Toolbar
The most reliable and easiest way to access this command without needing VBA code is by pinning it to your Quick Access Toolbar (QAT).
By default, Excel hides some specific paste actions within the Ribbon dropdown menus. Adding the command to the Quick Access Toolbar ensures it is always available with a single click, regardless of which Ribbon tab is currently active.
Click the small down arrow next to the Quick Access Toolbar at the top-left of the Excel window to open the drop-down menu.
Select 'More Commands...' from the drop-down list. This will open the Excel Options dialog box directly to the Quick Access Toolbar settings.
Under the 'Choose commands from' drop-down menu, select 'Commands Not in the Ribbon'.
Scroll down the alphabetical list to find 'Paste Values and Number Formatting'. Click on it to highlight it, then click the 'Add >>' button in the middle to move it to your active toolbar list.
Click 'OK' at the bottom of the window. The new paste icon will now appear permanently on your Quick Access Toolbar.
Use Built-in Keyboard Shortcuts
If you prefer not to modify the toolbar interface, you can rely on Excel's sequential shortcut keys to paste values and source formatting quickly.
Paste Values Instantly in WPS Office
If you are frustrated by Excel's hidden menus, WPS Spreadsheet offers an incredibly intuitive interface where common actions like 'Paste as Values' are readily available in the default right-click context menu, saving you time without requiring manual toolbar customizations.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Open Your Spreadsheet: Open your existing Excel file in WPS Spreadsheet without losing any formatting.
- 3. Copy Data: Select the cells you want to copy and press Ctrl + C.
- 4. Right-Click to Paste: Right-click the destination cell and simply select 'Paste as Values' directly from the pop-up context menu.
Frequently Asked Questions
Can I add Paste Values directly to the right-click context menu in Excel?
Yes, but it requires writing custom VBA (Visual Basic for Applications) code to modify the context menu natively. Because this is complex and requires saving the workbook as a macro-enabled file, adding the command to the Quick Access Toolbar is the highly recommended workaround for most users.
Why isn't Paste Values and Formatting easily visible on the main Ribbon?
By default, Microsoft Excel groups all paste variants under the single 'Paste' dropdown button on the Home tab to save space. You must click the small arrow below the Paste icon to expand the menu and see the Paste Values and Formatting option.
Will my Quick Access Toolbar customizations be applied to all future workbooks?
Yes. When you add a command to the Quick Access Toolbar, it applies globally to your Excel application on that specific computer, meaning it will be available in any new or existing workbook you open.
Is there a direct keyboard shortcut just for Paste Values?
In newer versions of Excel (Microsoft 365), you can use Ctrl + Shift + V to paste values directly. In older versions, you must use the sequence Alt > H > V > V, or use the Paste Special dialog via Ctrl + Alt + V.
