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