Question

How to add paste values in Excel Quick Access Toolbar?

Answer 1

To add paste values to the Quick Access Toolbar in Excel, right-click on the Quick Access Toolbar, choose 'Customize Quick Access Toolbar', select 'All Commands', find 'Paste Values', add it to the toolbar, and click 'OK'.

Step-by-step explanation:

To add paste values to the Quick Access Toolbar in Excel, follow these steps:

1. Click on the Excel ribbon and then right-click on the Quick Access Toolbar.
2. Select 'Customize Quick Access Toolbar' from the context menu. This will open the Excel Options dialog box.
3. In the Excel Options dialog box, choose 'All Commands' from the 'Choose commands from' drop-down list.
4. Scroll down the list of commands until you find 'Paste Values', which may be listed under 'Paste Special'.
5. Select 'Paste Values' and click the 'Add >>' button to add it to the Quick Access Toolbar.
6. Click 'OK' to close the dialog box. The Paste Values option should now be on your Quick Access Toolbar for easy access.

This allows you to quickly paste just the values of copied data without any formatting.