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!

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.

The cells will select but you will not be able to copy. When you select in Excel, you can do multiple cells or groups of cells.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

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.