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