ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/133051-subtotals.html)

zekni

Subtotals
 
Hello,

I should like to copy only the result of the subtotals (position 2)

How can it be done?

Thanks

Dave Peterson

Subtotals
 
After you used data|subtotals?

Hide the details
select the range to copy
edit|goto|special|visible cells only
edit|copy

And then paste where you want.

zekni wrote:

Hello,

I should like to copy only the result of the subtotals (position 2)

How can it be done?

Thanks


--

Dave Peterson

Lori

Subtotals
 
You can use the Alt+; shortcut for selecting visible cells before
copying.

On 2 Mar, 13:41, "zekni" wrote:
Hello,

I should like to copy only the result of the subtotals (position 2)

How can it be done?

Thanks





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com