Excel makes it ultra-easy to take a screenshot of any other open program on your desktop and insert it into a worksheet. Just go to Insert tab, select Screenshot, and you’ll get a dropdown showing a thumbnail of all the …
Daily Archives: Friday, May 31, 2019
How to remove all formula references but keep values in cells in Excel?
- Select the cells you need to remove all references, then press Ctrl + C keys, keep these cells selected, right click and select Values under Paste Options section.
- Then you can see all formula references of selected cells are