Excel tricks - copy and paste with values and formatting but without formula or references
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.
![[Lyrics] Lolo Zouaï - IDR](https://pics.providosiki.ru/watch/44OWTLv3Xms)
