To copy only visible cells in Excel or Google Sheets, use the 'Visible cells only' feature, or apply filters to hide data. We show you how!

Thats strange, because when I filter then copy rows in Excel 2007, it only copies the selected rows, not the hidden values.<BR><BR>This is Office 2007 SP1, BTW.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.

Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar.