Tip #052 – Excel

EXCEL: Copying Only VISIBLE Cells

You’ve just done a DATA-SUBTOTAL to a large spreadsheet list – to summarize the data and make it more readable. The individual data rows are hidden – great. But you’d like to COPY the summary rows (and only those rows) to another worksheet.

 

If you select the results – and copy and paste them elsewhere – the hidden data rows still show up. Ugh.

 

What to do?

 

Full tip: Excel tip