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.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.
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.