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.