You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Range » Paste values only
This will paste the copied data as values only.You can assign your own shortcut to this via the "Favorites & Shortcut keys" menu. This tool can speed things up when you use this often and save you a few strokes/mouse actions compared to the "Edit > Paste special > Values" via the menu in Excel when you assign a shortcut to it.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Range » Paste values only« Return to the list of “Range” tools.
| « Previous Paste values and formatting | Next » Copy selection and paste into only the visible cells... |
You can do this too
Download "The one essential add-in for all Excel users." Download
© 1999-2020 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
