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 |
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. |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com