How to Copy and Paste Visible Cells Only - Coin Inventory List Example - Working with Hidden Cells
Hello Everyone!
Here's a quick video on how to copy and paste only the visible cells.
Steps in this video
1. CTRL+A inside the table
2. From home tab under editing go to "Find and Select"
3. Go to "Go to special"
4. Click visible cells only
5. CTRL+C to copy the visible table
6. CTRL+V to paste the visible table
I hope this video helps and enjoy!