Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting Subtotal Results
I have a long worksheet with subtotals. I want to cut and paste the Subtotal Results only. If you cut and paste, when pasting, it shows everything that was in the subtotal. I just want to paste the result of the subtotal. I've tried cut and paste value only, but it doen't work. Does this make sense? Please Help!!! -- tchen ------------------------------------------------------------------------ tchen's Profile: http://www.excelforum.com/member.php...o&userid=26060 View this thread: http://www.excelforum.com/showthread...hreadid=393988 |
#2
|
|||
|
|||
I presume you've collapsed the subtotal outline and want to copy only the
values that are shown, not the hidden rows. To do this highlight the cells you want to copy and press CTRL+G to bring up the Goto window, click on the 'Special' button at the bottom of the window. Click to put a bullet beside 'Visible cells only'. Now press CTRL+C and you should see the dotted lines appear around each subtotal, click in the sheet where you want to paste and press CTRL+V and only the visible cells will be pasted. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "tchen" wrote: I have a long worksheet with subtotals. I want to cut and paste the Subtotal Results only. If you cut and paste, when pasting, it shows everything that was in the subtotal. I just want to paste the result of the subtotal. I've tried cut and paste value only, but it doen't work. Does this make sense? Please Help!!! -- tchen ------------------------------------------------------------------------ tchen's Profile: http://www.excelforum.com/member.php...o&userid=26060 View this thread: http://www.excelforum.com/showthread...hreadid=393988 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal - pivot table - or better function | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Sorting subtotal results | New Users to Excel | |||
Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |