Move sheet without links

[excelos]

Hello

When I copy a sheet to a new book, the cells contain links to other sheets.

Can I replace the links with the actual data easily and retaining the format?

Thanks!

 

[alansidman]

Use Copy and Paste Special, Values.

 

[excelos]

Use Copy and Paste Special, Values.

The problem with that is that it won't transfer the formatting!

 

[alansidman]

copy and paste special, values and source formatting.


Look at all the paste special options available. There are several.