Menu
![]() ![]() Replacing formulas with values in a couple of mouse clicks That's it! If this way is still not fast enough for you, have a look at the next tip. Shift + F10 + V is the shortest way to use Excel " Paste special - values only" dialog. Press Shift + F10 and then V to paste only values back to Excel cells.Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.Select all the cells with formulas that you want to convert. ![]() You need to replace its results with values. ![]() Suppose, you have the formula to extract domain names from URLs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |