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

preview_player
Показать описание
It took me quite some time to figure out how to do it, and I thought it was worth sharing with you. Please let me know what you think.
If you want to copy and paste a table or worksheet to another sheet while keeping all the formatting and values but removing all the references/links/formulas, this video will show you how exactly to do it. You can skip to 2:48 for the solutions directly.
Рекомендации по теме
Комментарии
Автор

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

jamesyuan
Автор

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

whateverish
Автор

Perfect, exactly what I was looking for!

Mark-Hall
Автор

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.

shalomosho