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
|
|||
|
|||
Copying information returned by using Sub Totals
Hi all
I have a large worksheet and have added a few sub totals to it. I have collapsed the data to the level I require and need to send this data to a colleague, however, I do not want them to see the rest of the information. If I simply copy and paste the worksheet, it copies the info in the background too. Is it possible to copy only the information you can actually see on the screen? Any urgent help would be appreciated. Thank you. Louise |
#2
|
|||
|
|||
Copying information returned by using Sub Totals
Hi Louise,
Hide the detail rows Select the range you want to copy EditGoto Click the [Special Cells] button Select: Visible Cells EditCopy "Louise" wrote: Hi all I have a large worksheet and have added a few sub totals to it. I have collapsed the data to the level I require and need to send this data to a colleague, however, I do not want them to see the rest of the information. If I simply copy and paste the worksheet, it copies the info in the background too. Is it possible to copy only the information you can actually see on the screen? Any urgent help would be appreciated. Thank you. Louise |
#3
|
|||
|
|||
Copying information returned by using Sub Totals
Louise,
It certainly is possible! Select the entire area you wish to copy CTRL +G and click Special Select the "visible cells only" option and press OK When you copy and paste only the visible results of your subtotals will appear. regards, Stevne |
#4
|
|||
|
|||
Copying information returned by using Sub Totals
Fantastic! I knew there must be a way, I never thought of that.
Thank you. Louise "Steven" wrote: Louise, It certainly is possible! Select the entire area you wish to copy CTRL +G and click Special Select the "visible cells only" option and press OK When you copy and paste only the visible results of your subtotals will appear. regards, Stevne |
Thread Tools | |
Display Modes | |
|
|