ExcelBanter - How do I copy subtotals from excel without it also copying the det

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy subtotals from excel without it also copying the det (https://www.excelbanter.com/excel-discussion-misc-queries/25840-how-do-i-copy-subtotals-excel-without-also-copying-det.html)

slh

How do I copy subtotals from excel without it also copying the det

Hi
Reduce the amount of subtotal detail to what you require. Hit F5 and click
on Special and then Visible Cells Only. You can now use Ctrl+C to copy this.
Go to where you want to paste these totals, and use Edit|Paste
Special|Values to paste.

--
Andy.

"slh" wrote in message
...

Mongoose

How do I copy subtotals from excel without it also copying the

"Andy B" wrote:

Hi
Reduce the amount of subtotal detail to what you require. Hit F5 and click
on Special and then Visible Cells Only. You can now use Ctrl+C to copy this.
Go to where you want to paste these totals, and use Edit|Paste
Special|Values to paste.

--
Andy.

"slh" wrote in message
...

All times are GMT +1. The time now is 10:05 AM.