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

Cell size 2
Password for cells and Password for sheet 2
Macro to traspose cell values 1
Convert Numbers stored as Text to Numbers 2
Set Column Width to Inches? 0
Use CountIf() with symbols 3
Convert hours to minutes 2
Insert a function in an entire column 3

Top