Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying multiple columns not adjacent
Is there a way that columns A B C F & G can be copied without including D E &
F? When I hide them, copy and then paste, it still includes the hidden columns. |
#2
|
|||
|
|||
Hold the control key as you click on the column's you want to copy. Then copy
and paste to the new sheet. "Doug Wilson" wrote: Is there a way that columns A B C F & G can be copied without including D E & F? When I hide them, copy and then paste, it still includes the hidden columns. |
#3
|
|||
|
|||
Couple of ways.
Select A, B, and C, Hold <Ctrl, Select F, and G, Then right click in the selection and choose "Copy", Click in the starting cell or column of the new location, And Paste. If D and E are hidden, Select A to G, Then <F5 <Special Click "Visible Cells Only", <OK Then complete your Copy and Paste. The Paste will copy to a *contiguous* range in the new location. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Doug Wilson" wrote in message ... Is there a way that columns A B C F & G can be copied without including D E & F? When I hide them, copy and then paste, it still includes the hidden columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |