Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting all but Column widths doesnt get pasted.
Hi,
If I copy a range of data (single column , many rows) and paste in to another worksheet/workbook then column widths are not pasted properly. If I go to paste special and use -- All-- it still wont work. I have to first use paste special - Column Width - and then if I do ctrl + v immediately it will work. Is the option --All -- not a super-set of -- Column Width-- in Paste special ? If the above is NO, shouldnt the paste special option box be a Check box rather than a Radio button? Did MS intentionally designed it that way or am I missing something. Thanks a lot, Hari India |
#2
|
|||
|
|||
Hi, Hari Prasadh;
I use "Insert Copied Cells" for that. Regards, Ian. "Hari Prasadh" wrote: Hi, If I copy a range of data (single column , many rows) and paste in to another worksheet/workbook then column widths are not pasted properly. If I go to paste special and use -- All-- it still wont work. I have to first use paste special - Column Width - and then if I do ctrl + v immediately it will work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing column widths in certain cells | Excel Discussion (Misc queries) | |||
Column widths to adjust automatically? | Excel Discussion (Misc queries) | |||
how to copy sheets keeping defined column widths | Excel Worksheet Functions | |||
Vary the column widths for different rows | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) |