Work with Visible Cells Only

When you have few rows / columns hidden in between cells that you copy and paste, Excel copies and pastes contents of those cells which are hidden too. Or if you select any range and apply some formatting, Excel applies that formatting to hidden cells in that range as well. So what if you want to copy only visible cells or apply formatting to visible cells only?

Select the range you want, press Alt and ; (semicolon). This action selects only those cells which are visible. Copy and choose any place and paste it. Or apply any format you want and that will be applied only to visible cells.

Above method works. However there is another option if you want to simply copy and paste visible cells. Once you copy, paste this from Office Clipboard rather than using Enter or Ctrl+V. 

How to access Office Clipboard

To paste only visible cells, after you copy, select where you want to paste these values and follow the below steps.

Excel 2007 or later

Home tab > Clipboard group > click on the small arrow that is at the bottom right of this group. It will be under Format Painter option.Clicking this arrow opens up Clipboard. Locate your copied values and click on them with mouse.

Excel 2003 or earlier

Edit menu > Office Clipboard. Clicking this opens up Clipboard. Locate your copied values and click on them with mouse.

Note: Press Ctrl+C two times while copying will also opens up Office Clipboard under default conditions.