How to copy only visible cells in Excel?
When you set some rows and columns to be hidden in a worksheet and want to copy the only visible cells in Excel, can you just directly copy and paste it in Excel? No, there are some tricky things you should know for doing so. Please go through the following steps to know how you could only copy the visible cells in Excel.
1. Select the range that you want to copy.
2. Click Home > Find & Select > Go To Special, and a Go To Special dialog box will appear. See screenshot:
3. Then check the Visible cells only option. And click OK.
4. And the visible cells will be selected only. Then you can copy them and paste them to anywhere without the hidden rows or columns.