CaP'N GRuNGe Posted December 30, 2008 Share Posted December 30, 2008 Anybody know if it's possible to copy and paste subtotals so you only paste the visible subtotals and not the hidden rows with the detail? I'm using Office 2007. I've never been able to do this in the past. I think... Quote Link to comment Share on other sites More sharing options...
godtomsatan Posted December 30, 2008 Share Posted December 30, 2008 Anybody know if it's possible to copy and paste subtotals so you only paste the visible subtotals and not the hidden rows with the detail? I'm using Office 2007. I've never been able to do this in the past. I think... just make the new cell = to a value in a different cell. Quote Link to comment Share on other sites More sharing options...
CaP'N GRuNGe Posted December 30, 2008 Author Share Posted December 30, 2008 Phew...found it... http://www.mrexcel.com/tip003.shtml Nice. Quote Link to comment Share on other sites More sharing options...
CaP'N GRuNGe Posted December 30, 2008 Author Share Posted December 30, 2008 just make the new cell = to a value in a different cell. Too many cells... Quote Link to comment Share on other sites More sharing options...
AtomicCEO Posted December 30, 2008 Share Posted December 30, 2008 Copy, Paste Special as "Value"? Quote Link to comment Share on other sites More sharing options...
Ursa Majoris Posted December 30, 2008 Share Posted December 30, 2008 (edited) Phew...found it... http://www.mrexcel.com/tip003.shtml Nice. I had the same problem for weeks until I tracked down the answer. You'd think this would be one of the options on the Paste Special list. Edited December 30, 2008 by Ursa Majoris Quote Link to comment Share on other sites More sharing options...
Big Country Posted December 30, 2008 Share Posted December 30, 2008 If this is something that you will be doing often, you can add the "Select Visible Cells Only" to a toolbar and then all you have to do is highlight the data you want, click the button on the toolbar, then ctrl-c. I do it all the time. Quote Link to comment Share on other sites More sharing options...
Ursa Majoris Posted December 30, 2008 Share Posted December 30, 2008 If this is something that you will be doing often, you can add the "Select Visible Cells Only" to a toolbar and then all you have to do is highlight the data you want, click the button on the toolbar, then ctrl-c. I do it all the time. Thanks - that will help a lot when I'm doing the monthly budget forecast. Quote Link to comment Share on other sites More sharing options...
Big Country Posted December 30, 2008 Share Posted December 30, 2008 On a separate note, since I obviously don't see the worksheet you are working with or know what ype of data you are working with, but any reason you are using the subtotal function and not a PivotTable? Quote Link to comment Share on other sites More sharing options...
CaP'N GRuNGe Posted December 30, 2008 Author Share Posted December 30, 2008 On a separate note, since I obviously don't see the worksheet you are working with or know what ype of data you are working with, but any reason you are using the subtotal function and not a PivotTable? I tend to avoid them as I have never really sat down to figure them out. I can use them if someone else has set them up already. Quote Link to comment Share on other sites More sharing options...
westvirginia Posted December 31, 2008 Share Posted December 31, 2008 If this is something that you will be doing often, you can add the "Select Visible Cells Only" to a toolbar and then all you have to do is highlight the data you want, click the button on the toolbar, then ctrl-c. I do it all the time. Winner-winner, chicken dinner. I add that icon first thing when setting up a new PC or new version of Excel. On a separate note, since I obviously don't see the worksheet you are working with or know what ype of data you are working with, but any reason you are using the subtotal function and not a PivotTable? Amen, depending on what you're doing. Grungie - pivot tables are really a snap. Since you've got your data in enough of a tabular format to use subtotals, pivot tables won't take you more than ten minutes of playing to figure out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.