| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste into range with hidden columns
I have data in columns A:Z on Sheet 1. I need to copy/paste this data onto
Sheet 2, but the range I want to Paste over has multiple hidden columns (calculations) that I want to 'skip over' so they remain intact. In other words, I want to paste into the 'visible' columns on Sheet 2. Is there any way to do this? I thought perhaps I could use the Goto...Special...Visible Cells when I do the Paste process, this doesn't seem to work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
| copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
| Not include hidden columns in copy paste | Excel Discussion (Misc queries) | |||
Threaded Mode
