Excel tricks - copy and paste with values and formatting but without formula or references

[@jamesyuan97]

I am glad someone out there found this was helpful :-)

[@whatever2222ish]

THANK YOU! I was going crazy trying to keep the row height as well.

[@Mark-Hall]

Perfect, exactly what I was looking for!

[@vyvrtkanatebe9735]

You're a GENIUS!!!

[@andylin6200]

Great work. thanks a million

[@kevincvz7_483]

Thanks bro you saved me 🙏

[@jamesyuan97]

I'm glad it helped. Thank you for your comment too.

[@pankajkushwaha4289]

Thank you very much!

[@mitchellisabeast1]

Bless up!!! Thank you!

[@Kartik_Lipne_Patil]

THANK YOU

[@shalomosho2204]

This was super helpful. Thank you. However, when I tried to copy and paste to keep column width and height, it only pasted column width. I'm wondering what I missed.

[@jamesyuan97]

Thank you for sharing your experience. Not sure why it did not keep row height, maybe because we were using different Excel versions.

[@Abhishekverma-uh8hy]

Thanks..... 👍👍👍

[@TrongNguyen-lq8gd]

Genius 🤘🤘🤘🤘🤘

[@fesalaziz1511]

Thanx so much