Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

http://www.excelcampus.com/paste-buddy
Learn a few tips for pasting to a range that contains hidden rows or columns, when you want to copy & paste to the visible cells only. This allows you to skip the hidden rows or columns when pasting. If you are receiving the error message, "This command cannot be used on multiple selections", this video explains a few workaround solutions.


The following video shows how to select the visible cells with the keyboard shortcut Alt+; https://www.youtube.com/watch?v=9k5Zngv_ulE
00:00 Introduction
00:40 Select Visible Cells
01:45 Paste Visible