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!

With Paste Special in Microsoft Excel, you can copy and paste more than a cell's contents or formatting. Indeed, you can also duplicate a cell's comment or note in another cell.

Capturing Regular Cells Excel's Camera and Linked Picture tools can both be used to take snapshots of a cell or range of cells that aren't formatted as tables.