| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying one column with hidden/filtered rows to another colum
How can I copy column with hidden rows/filterd into another column with
visible rows only to be exactly paste in another column. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying one column with hidden/filtered rows to another colum
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rechie" wrote: How can I copy column with hidden rows/filterd into another column with visible rows only to be exactly paste in another column. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying one column with hidden/filtered rows to another colum
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. "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rechie" wrote: How can I copy column with hidden rows/filterd into another column with visible rows only to be exactly paste in another column. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip hidden rows while copying down in excel? | Excel Discussion (Misc queries) | |||
| hidden/filtered rows | Excel Discussion (Misc queries) | |||
| copying and pasting with hidden rows | Excel Discussion (Misc queries) | |||
| Unique Count sensitive to hidden/filtered rows | Excel Worksheet Functions | |||
| Copying data without hidden rows. | Excel Worksheet Functions | |||
Hybrid Mode
