Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Excel Subtotals

Posted by Gary on February 07, 2002 10:13 AM

I have a list of subtotaled numbers. I would like to copy and paste all the subtotal formulas (approximatley 200) to another column without bringing over the numerical data, formulas only. In this particular case, I cannot take off the subtotals and subtotal again. The original criteria for subtotaling is long gone. I've also tried the copy and paste formulas with no luck. Any ideas?

Re: Excel Subtotals

Posted by denis on February 07, 2002 12:31 PM

select all the subtotal column's, then click edit\goto then click the special button & select visible cell's only. then copy & paste

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.