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!

Before doing anything with the subtotals, you must remember to apply the Visible Cells Only option. If you forget, Excel will apply the format to all of the data cells as well.

To count colored cells in Microsoft Excel, you may use the Find and Select tool or the Excel Filter and SUBTOTAL() function.

Copy, Move, and Link Cell Elements There are many ways to copy and move data, duplicate forming, and link cells together in Microsoft Excel. For example, you could use Paste Special, Format ...