Asi
11-18-2009, 03:28 AM
Hi
I have two Sheets with the same table formats. Source Sheet & Destination Sheet. Both Sheets have hidden columns (as I said same tables in both so same columns are hidden).
In the Source Sheet I filter the data and then select the filtered rows and copy. In the destination sheet I select the first cell and paste.
The problem is that the data is shifted to the right because of the hidden column. The copy operation copied ONLY the visible columns (without the hidden ones) and The Paste operation pasted it into the hidden columns.
If I do the same thing without filtering - there is no problem and all columns are copied into the correct place including the hidden ones.
This is how Excel acts. The question is - Is there a way to copy all columns including hidden (after filtering) or do I need to unhide -> Copy -> hide ?
Thanks
Asi
I have two Sheets with the same table formats. Source Sheet & Destination Sheet. Both Sheets have hidden columns (as I said same tables in both so same columns are hidden).
In the Source Sheet I filter the data and then select the filtered rows and copy. In the destination sheet I select the first cell and paste.
The problem is that the data is shifted to the right because of the hidden column. The copy operation copied ONLY the visible columns (without the hidden ones) and The Paste operation pasted it into the hidden columns.
If I do the same thing without filtering - there is no problem and all columns are copied into the correct place including the hidden ones.
This is how Excel acts. The question is - Is there a way to copy all columns including hidden (after filtering) or do I need to unhide -> Copy -> hide ?
Thanks
Asi