MrExcel.com - Your One Stop for Excel Tips & Solutions

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?

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