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 » Copy selection and paste into only the visible cells...
This tool copies the visible cells in your current selection and then pastes these into only the visible cells in a given destination range.If there are hidden rows or columns in either the source or target range, then those will be skipped. The data will then be pasted into the first next visible row or column.
This tool can be useful when pasting data into a filtered list.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Range » Copy selection and paste into only the visible cells...« Return to the list of “Range” tools.
| « Previous Paste values only | Next » Fill cells with their formatted value |
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:
