If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy subtotals
You just saved me a TON of work!!
Thanks for the very helpful post! Erin -----Original Message----- If this has to be done often, there is an icon which can be placed on the tool bar for much easier and quicker utilization. Right click in the tool bar and choose Customize, Click on the Commands tab, In the "Categories" window, click on Edit, In the "Commands" window, scroll to the next to last icon, which is the "Select Visible Cells" one, Click on it and drag to the tool bar. HTH, RD "JohnI in Brisbane" wrote in message ... Mary, 1) First select your data range as usual 2) Select "Edit" - Select "Go To..." - Select "Special..." button - Select "Visible Cells Only" - click "OK" button. 3) Click "Edit - Click "Copy" 4) Select where you want to paste. 5) Paste as usual regards, JohnI "Mary" wrote in message ... I would like to work with my collapsed subtotals without the associated detailed rows. When I try to copy a set of collapsed subtotals (that is, a set in which I have clicked the #2 in the far left corner), and try to copy that information, it pastes the subtotals plus all of the hidden rows. Can anyone tell me how I can work with only the subtotals of a spreadsheet? Thanks . |
#2
|
|||
|
|||
Copy subtotals
My Pleasure !
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Erin Paulin" wrote in message ... You just saved me a TON of work!! Thanks for the very helpful post! Erin -----Original Message----- If this has to be done often, there is an icon which can be placed on the tool bar for much easier and quicker utilization. Right click in the tool bar and choose Customize, Click on the Commands tab, In the "Categories" window, click on Edit, In the "Commands" window, scroll to the next to last icon, which is the "Select Visible Cells" one, Click on it and drag to the tool bar. HTH, RD "JohnI in Brisbane" wrote in message ... Mary, 1) First select your data range as usual 2) Select "Edit" - Select "Go To..." - Select "Special..." button - Select "Visible Cells Only" - click "OK" button. 3) Click "Edit - Click "Copy" 4) Select where you want to paste. 5) Paste as usual regards, JohnI "Mary" wrote in message ... I would like to work with my collapsed subtotals without the associated detailed rows. When I try to copy a set of collapsed subtotals (that is, a set in which I have clicked the #2 in the far left corner), and try to copy that information, it pastes the subtotals plus all of the hidden rows. Can anyone tell me how I can work with only the subtotals of a spreadsheet? Thanks . |
Thread Tools | |
Display Modes | |
|
|