Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hidden Cells
Sorry another issue. I have a spreadshseet with values in A1 B1 & C1. Column B is hidden. I want to copy the values in A1:C1 and paste these into F1:G1 but i don't want the value in hidden cell (B1) to be included in the pasted items. Cheers Simon -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=504183 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hidden Cells
Try selecting your range (A1:C1)
edit|goto|special visible cells only edit|copy Select F1 edit|paste (but if it's really only two cells, I'd just copy them one at a time.) sgrech wrote: Sorry another issue. I have a spreadshseet with values in A1 B1 & C1. Column B is hidden. I want to copy the values in A1:C1 and paste these into F1:G1 but i don't want the value in hidden cell (B1) to be included in the pasted items. Cheers Simon -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=504183 -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hidden Cells
Hi i have done exactly what you said but the result that only the cell A1 is pasted? -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=504183 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hidden Cells
If you pasted into G1, then check to see if column H is hidden--maybe you pasted
into a hidden column. sgrech wrote: Hi i have done exactly what you said but the result that only the cell A1 is pasted? -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=504183 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to only "paste values" of cells that are not "hidden"? | Excel Discussion (Misc queries) | |||
copying with hidden cells | Excel Worksheet Functions | |||
hidden cells | Excel Discussion (Misc queries) | |||
HOW DO I PREVENT HIDDEN CELLS FROM DISPLAYING WHEN I COPY | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |