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.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
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.
Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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:

doc-copy-only-visible-cells

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.


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

-1#Manber2014-03-31 05:47
But this formula not applicable for merge cells. can you please share a formula applicable for merge unhide cells also.
Reply | Reply with quote | Quote

Add comment


Security code
Refresh