| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying subtotals Only
Hi I have a huge tax spreadsheet I subtotal by county, the only problem is
when I try to copy only the visible cells, I get everything... Short of deleting all the lines in between is there an easiser way?? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying subtotals Only
Try this method:
Set only subtotal rows visible! EditGotoAdvancedCurrent Area EditGotoAdvancedVisible cells only Copy and Paste! Regards, Stefi €˛mods1€¯ ezt Ć*rta: Hi I have a huge tax spreadsheet I subtotal by county, the only problem is when I try to copy only the visible cells, I get everything... Short of deleting all the lines in between is there an easiser way?? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying subtotals Only
Hi,
Highlight the cells to be copy, press F5, Special, visible cells only, copy, paste "mods1" wrote: Hi I have a huge tax spreadsheet I subtotal by county, the only problem is when I try to copy only the visible cells, I get everything... Short of deleting all the lines in between is there an easiser way?? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Labels in Subtotals | Excel Discussion (Misc queries) | |||
| Copying Subtotals to new worksheet | Excel Worksheet Functions | |||
| Copying subtotals | Excel Discussion (Misc queries) | |||
| subtotals copying | Excel Discussion (Misc queries) | |||
| Copying Subtotals? | Excel Discussion (Misc queries) | |||
Linear Mode
