Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Avoiding totals of Duplicate Information | Excel Discussion (Misc queries) | |||
copying information | New Users to Excel | |||
Add more information in Sub Totals | Excel Discussion (Misc queries) | |||
Returned: Copying a formula horizontally, the source data is verti | Excel Discussion (Misc queries) | |||
Displaying YTD totals as you populate monthly information | Excel Worksheet Functions |