The ASAP Utilities menu in Excel (English)
Copy Visible Cells and Paste to Visible Cells in Target Range...
ASAP Utilities › Range › 12. Copy Visible Cells and Paste to Visible Cells in Target Range...This tool copies only the visible cells from your current selection and pastes them into the visible cells of a target range. It works similarly to Excel's standard copy and paste: everything in each visible cell is copied (values, formatting, formulas, comments, etc.). The difference is that this tool automatically skips hidden rows and columns in both the source and the destination. The content is pasted one cell at a time into the next visible cells in the target range. When the tool starts, you can select the first cell of the destination range. The address of your current selection is shown in the dialog for reference. This is helpful when:
Screenshots
Starting this tool
- Click ASAP Utilities › Range › 12. Copy Visible Cells and Paste to Visible Cells in Target Range...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
copy visible cells only, paste into visible cells, paste to filtered rows only, Excel copy skip hidden rows, paste into filtered list, paste without affecting hidden rows, copy and paste visible cells, copy skip hidden rows and columns, Excel paste filtered range, paste data into visible cells, copy filtered data to visible cells, Excel copy paste visible only, copy to visible cells in target range
copy visible cells only, paste into visible cells, paste to filtered rows only, Excel copy skip hidden rows, paste into filtered list, paste without affecting hidden rows, copy and paste visible cells, copy skip hidden rows and columns, Excel paste filtered range, paste data into visible cells, copy filtered data to visible cells, Excel copy paste visible only, copy to visible cells in target range
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Paste Values Without Formatting |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.