Copy & Paste Visible Cells Only in Excel for Windows or Mac
http://www.excelcampus.com/newsletter Use this simple keyboard shortcut to select the visible cells only when copying and pasting a range with hidden rows or columns or filtered data. Windows: Alt+; Mac: Cmd+Shift+Z The following video explains a few tricks for pasting to the visible cells when the range contains hidden rows or columns. https ...
YouTube
· Jul 17, 2014