Adding Paste Values to the Quick Access Toolbar in Excel 2007
Using the Paste Values option in Excel lets you strip
formulas from your data and paste only the resulting values. In Excel 2007
the Quick Access Toolbar is a great way to simplify using this feature.
Here's how:
 |
Click the Office button in the upper left
corner of the Excel 2007 Screen |
|
|
Click the Excel Options button at the bottom of
the Office window to display the Excel Options dialog box |
|
|
Click Customize in the left pane |
|
|
Under Choose commands select All Commands |
|
|
Select Paste Values |
|
|
Click Add and then OK
|
|
