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 special (with combinations)...
This utility does a "Paste Special", where you can use a combination from the options.With the built in Excel "Paste Special" dialog you can only paste one item at a time. With this utility you can now for example past both values, comments and formatting in one step.
Follow the following steps to use this:
1. Copy your datarange (for example with Ctrl+C).
2. Select the cell or range where you want to paste
3. Start this utility to paste the information/properties.
By default you can start this utility with the shortcut Control+Alt+Y.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Range » Paste special (with combinations)...« Return to the list of “Range” tools.
| « Previous Custom formula error message... | Next » Paste values and formatting |
You can do this too
Download "The one essential add-in for all Excel users."
© 1999-2021 - 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:
