| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the Subtotal function
After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the Subtotal function
You can, but you will need to PasteSpecialValues if you want that exact
value. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mark" wrote in message ... After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the Subtotal function
On Jul 15, 12:41 pm, Mark wrote:
After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal Also, you probably need to select the column of Subtotals, then use Goto|Special to select Visible Cells Only, then hit Copy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal Function | Excel Worksheet Functions | |||
| Subtotal function not available | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
| Subtotal function (again) | Excel Worksheet Functions | |||
Hybrid Mode
