Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
How many values appear more than once in a range? | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |