Hided values appears when I'm copying/pasting it to other worksheet
 

So,

in one worksheet I have some data and there is some colums hided.
When I selecting all that data and pasting to other worksheet, all
these hided colums or rows values appears and I have to hide it again.

Is there possibility to copy/paste in such way, that these hided values
don't appear again?

Thanks in advance

Best Regards,
Aivaras


--
Aivaras_Bakanas
------------------------------------------------------------------------
Aivaras_Bakanas's Profile: http://www.excelforum.com/member.php...o&userid=25188
View this thread: http://www.excelforum.com/showthread...hreadid=386750

After selecting your range, hit Edit--Go to--Special, Visible Cells Only,
OK. Then copy and paste.
*******************
~Anne Troy

www.OfficeArticles.com


"Aivaras_Bakanas"
<Aivaras_Bakanas.1s4080_1121260191.9176@excelfor um-nospam.com wrote in
message news:Aivaras_Bakanas.1s4080_1121260191.9176@excelf orum-nospam.com...

So,

in one worksheet I have some data and there is some colums hided.
When I selecting all that data and pasting to other worksheet, all
these hided colums or rows values appears and I have to hide it again.

Is there possibility to copy/paste in such way, that these hided values
don't appear again?

Thanks in advance

Best Regards,
Aivaras


--
Aivaras_Bakanas
------------------------------------------------------------------------
Aivaras_Bakanas's Profile:
http://www.excelforum.com/member.php...o&userid=25188
View this thread: http://www.excelforum.com/showthread...hreadid=386750

Select the range to copy
edit|goto|special|visible cells only

Then copy|paste

(but this pastes formulas as values--is that a problem?)

Aivaras_Bakanas wrote:

So,

in one worksheet I have some data and there is some colums hided.
When I selecting all that data and pasting to other worksheet, all
these hided colums or rows values appears and I have to hide it again.

Is there possibility to copy/paste in such way, that these hided values
don't appear again?

Thanks in advance

Best Regards,
Aivaras

--
Aivaras_Bakanas
------------------------------------------------------------------------
Aivaras_Bakanas's Profile: http://www.excelforum.com/member.php...o&userid=25188
View this thread: http://www.excelforum.com/showthread...hreadid=386750

--

Dave Peterson