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. • How To Paste to Visible Cells in Excel
Here is the article where I explain this technique in more detail. https://www.excelcampus.com/keyboard-...
Watch video Copy & Paste Visible Cells Only in Excel for Windows or Mac online without registration, duration hours minute second in high quality. This video was added by user Excel Campus - Jon 16 July 2014, don't forget to share it with your friends and acquaintances, it has been viewed on our site 416,116 once and liked it 855 people.