copying one column with hidden/filtered rows to another colum

R

Rechie

How can I copy column with hidden rows/filterd into another column with
visible rows only to be exactly paste in another column.

Thanks
 
L

Luke M

After selected the column with fitlered rows, press Ctrl+G to bring up the
GoTo dialogue. Click special, then choose "Visible Cells Only". Copy these
cells, and then paste.
 
R

Rechie

Thanks, sorry I forgot to mentioned that the target column has data in the
hidden rows. Is it possible that it will not be replaced from the source data
(data in copy from column) ?

Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copying and pasting to visible cells only 4
Pasting into a filtered sheet 3
Copy Filtered column in Full 2
HOw can I paste data into a column with autofilter? 1
How do I Copy and Paste onto Same Rows after filtering out rows. 2
drag data vertically over hidden cells.. ignore hidden cells 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3

Top