MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by chrystal on January 24, 2000 3:13 PM

once you've subtotaled data, is there a way to copy
and paste only the second level of subtotals?
in level 2, if you copy two lines of data, you also
copy all rows in between.
i've tried ctrl + only the lines i want
but that is very tedious for hundreds of lines

Posted by Celia on January 24, 2000 3:54 PM

With only the sub-totals visible, click the Edit menu and select GoTo-Special-Visible Cells Only.
Then copy and paste.