| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy visble cells at the subtotal level
When I try to copy just the visible cells after I have subtotaled, it pastes
all the details even when I paste special (just values). SOmeone told me there is a view/copy visible cells icon but I can't find it. Thank you |
|
#2
|
|||
|
|||
|
To find the icon, go into the Customize Toolbars menu. On the commands tab,
pick Edit. Way at the bottom is an icon that looks like four black boxes stacked together that says "Select Visible Cells." Add that to one of your toolbars. Then, once you've higlighted the subtotal rows, hit the new button, then copy. When you paste values, it should remove the details. "jfkosu" wrote: When I try to copy just the visible cells after I have subtotaled, it pastes all the details even when I paste special (just values). SOmeone told me there is a view/copy visible cells icon but I can't find it. Thank you |
|
#3
|
|||
|
|||
|
Try F5SpecialVisible cells only and OK.
The button/icon is located in ToolsCustomizeCommandsEdit. Scroll down to the bottom to find it. Move it up to your Toolbar if you wish. Gord Dibben Excel MVP On Wed, 30 Mar 2005 14:25:04 -0800, jfkosu wrote: When I try to copy just the visible cells after I have subtotaled, it pastes all the details even when I paste special (just values). SOmeone told me there is a view/copy visible cells icon but I can't find it. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy and paste cells incrementally? | Excel Worksheet Functions | |||
| loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
| How do I copy cells and skip lines? | Excel Discussion (Misc queries) | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
