| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying subtotals in Excel 2000
When I try and copy subtotals to a second sheet all rows are displayed. How
can I copy just the subtotals? -- pearsall |
|
#2
|
|||
|
|||
|
Display only the subtotal rows
Select the entire range Press the F5 key and click on Special Check 'Visible cells only' Click on OK Copy Go to your other sheet EditPaste Special Values "pearsall" wrote: When I try and copy subtotals to a second sheet all rows are displayed. How can I copy just the subtotals? -- pearsall |
|
#3
|
|||
|
|||
|
When copying subtotals, EditPaste Special Values isn't necessary
Using EditPaste is quicker, and has the same result Duke Carey wrote: Display only the subtotal rows Select the entire range Press the F5 key and click on Special Check 'Visible cells only' Click on OK Copy Go to your other sheet EditPaste Special Values "pearsall" wrote: When I try and copy subtotals to a second sheet all rows are displayed. How can I copy just the subtotals? -- pearsall -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
Thanks for the insight Debra.
Live and learn "Debra Dalgleish" wrote: When copying subtotals, EditPaste Special Values isn't necessary Using EditPaste is quicker, and has the same result Duke Carey wrote: Display only the subtotal rows Select the entire range Press the F5 key and click on Special Check 'Visible cells only' Click on OK Copy Go to your other sheet EditPaste Special Values "pearsall" wrote: When I try and copy subtotals to a second sheet all rows are displayed. How can I copy just the subtotals? -- pearsall -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| How can I use Excel 2003 to sit for exams which are in Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Linear Mode
