Copy and paste visible cells in the same worksheet

[Lulu]

Select the visible cells.
Edit|goto|special|visible cells only
You should be on the top cell of the selection
type an equal sign (=) and then hit the left arrow
(or type an equal sign and point to the cell in the same row)
hit ctrl-enter to fill the selection with the same formula

If all the cells in that second column are values, you can convert the entire
column to values. Then clean up the "sending" cells if you need to

I understand the GOTO function, however I cannot figure out how to paste in another column in the same worksheet with out the hidden cells copying also.

 

[Sam Mathai Chacko]

I would have thought it's straight forward. In a normal sense, you just need to copy the entire range of cells and paste it elsewhere. This will not copy the hidden cells. Since you are mentioning something about 'cleaning up' the cells, maybe you want to attach a sample file and explain your requirement.

 

[bobhc]

Good day Lulu


Select the cells that you want to copy.
On the Home tab, in the Editing group, click Find & Select, and then click Go To.
In the Go To dialog box, click Special.
Under Select, click Visible cells only, and then click OK.
On the Home tab, in the Clipboard group, click Copy .
Select the upper-left cell of the paste area.
On the Home tab, in the Clipboard group, click Paste .