| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Just UnHidden?
I have some data in which I have hidden some Columns and some Rows. I would
loke to copy just the visible portion into a new WS. Ctrl+A is like a love-in at Grammercy Park -- everyone is a friend. Need to be more selective (never know what you might catch <g)! -- Dave Temping with Staffmark in Rock Hill, SC |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Just UnHidden?
Select what you want to copyf5specialvisiblecellsselect where you want
to pastepaste -- Don Guillett SalesAid Software "Dave Birley" wrote in message ... I have some data in which I have hidden some Columns and some Rows. I would loke to copy just the visible portion into a new WS. Ctrl+A is like a love-in at Grammercy Park -- everyone is a friend. Need to be more selective (never know what you might catch <g)! -- Dave Temping with Staffmark in Rock Hill, SC |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Just UnHidden?
Than Kieu (the famouns Vietnamese patriot). I knew there was a way <g! (Oh
yeah, and I checked -- it's Gramercy Park -- one 'm'. I'm old, I forget <g) -- Dave Temping with Staffmark in Rock Hill, SC "Don Guillett" wrote: Select what you want to copyf5specialvisiblecellsselect where you want to pastepaste -- Don Guillett SalesAid Software "Dave Birley" wrote in message ... I have some data in which I have hidden some Columns and some Rows. I would loke to copy just the visible portion into a new WS. Ctrl+A is like a love-in at Grammercy Park -- everyone is a friend. Need to be more selective (never know what you might catch <g)! -- Dave Temping with Staffmark in Rock Hill, SC |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Just UnHidden?
Follow Dave's recommendations but also make sure that you don't have any
merged cells in your selection! -- rb in Shakopee "Dave Birley" wrote: I have some data in which I have hidden some Columns and some Rows. I would loke to copy just the visible portion into a new WS. Ctrl+A is like a love-in at Grammercy Park -- everyone is a friend. Need to be more selective (never know what you might catch <g)! -- Dave Temping with Staffmark in Rock Hill, SC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [newbie] copy unhidden cells | Excel Discussion (Misc queries) | |||
| unhidden row only | Excel Discussion (Misc queries) | |||
| How do I copy only the unhidden rows/colums? | Excel Discussion (Misc queries) | |||
| How do I copy & paste only the unhidden data on a worksheet ? | Excel Discussion (Misc queries) | |||
| copy and paste only unhidden information | Excel Discussion (Misc queries) | |||
Linear Mode
