Column width

E

Emece

In Sheet 1 I have a certain amount of data, I want to select some cells and
copy them to Sheet 2 keeping the same format. When I do this, the fonts and
the colours remain unchanged, but the column width don't. I have tried paste
special, but couldn't figure it out. Is this possible?

Thanks in advance

Regards,
Emece.-
 
J

Jacob Skaria

--Copy range
--Select the target cell and right click >PasteSpecial>All>OK
--Keeping the target selection right click>PasteSpecial>select ColumnWidth>OK

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
Excel Column Width in XLSX 0
Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
Table Preferred width is changed when pasting 1
Cell size 2
Set Column Width to Inches? 0
Password for cells and Password for sheet 2

Top