Hidden Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sgrech - 23 Jan 2006 21:07 GMT

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

Signature

sgrech

Reply to this Message

Dave Peterson - 23 Jan 2006 21:27 GMT

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.)

> 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
[quoted text clipped - 9 lines]
> sgrech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14501
> View this thread: http://www.excelforum.com/showthread.php?threadid=504183

Signature

Dave Peterson

Reply to this Message

sgrech - 23 Jan 2006 22:41 GMT

Hi i have done exactly what you said but the result that only the cel
A1 is pasted

Reply to this Message

Dave Peterson - 23 Jan 2006 23:05 GMT

If you pasted into G1, then check to see if column H is hidden--maybe you pasted
into a hidden column.

> Hi i have done exactly what you said but the result that only the cell
> A1 is pasted?
[quoted text clipped - 4 lines]
> sgrech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14501
> View this thread: http://www.excelforum.com/showthread.php?threadid=504183

Signature

Dave Peterson

Reply to this Message