# ASAP Utilities, description of our Excel tools English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

## Formulas » Change formulas to their calculated values

This utility replaces the formulas in the selected cells with their calculated values.

The utility works the same as Excel's 'Copy » Paste special » Paste values' but in one step and it also works with multiple selections at once.
Normally the utility changes the formulas to their calculated values in both visible and hidden cells. If you have selected cells in a filtered list only the visible cells are changed.

As an example, a cell with the formula '=A2*(C19/12)' which has '124' as the calculated result will be replaced with the value 124.
This can be useful, for example if you want to speed up the calculation of your workbook or if you don't want someone to see the underlying formulas you used if you give the workbook to somebody else.

By default you can start this utility with the shortcut Control+Alt+P.

## Screenshots

Example screenshot: 1 Change formulas to their calculated values Example screenshot: 2 Formulas to values in a filtered list is something that you normally can't do in Excel ## Starting this utility

In the Excel menu choose: ASAP Utilities » Formulas » Change formulas to their calculated values

« Return to the list of “Formulas” tools.

Printer friendly page
© 1999-2021 - - - - The Netherlands
{"ft_lang_label":"__label__en","ft_lang_prob":0.8248728,"math_prob":0.60968083,"size":1591,"snap":"2021-04-2021-17","text_gpt3_token_len":365,"char_repetition_ratio":0.13295527,"word_repetition_ratio":0.02189781,"special_character_ratio":0.22438718,"punctuation_ratio":0.049822062,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.95892453,"pos_list":[0,1,2,3,4,5,6,7,8],"im_url_duplicate_count":[null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-04-10T19:48:56Z\",\"WARC-Record-ID\":\"<urn:uuid:e7bdf3be-8364-4c1a-882e-ae1a976af849>\",\"Content-Length\":\"32347\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:77c9e9ea-d8a2-466f-841d-ace3742d8bf1>\",\"WARC-Concurrent-To\":\"<urn:uuid:435030ad-1209-438a-a69b-dc45cd609d20>\",\"WARC-IP-Address\":\"195.190.28.230\",\"WARC-Target-URI\":\"https://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=99&utilities=97&lang=en_us\",\"WARC-Payload-Digest\":\"sha1:2JQWI56KXA35RTYH47PKZKGBMVHWA6X3\",\"WARC-Block-Digest\":\"sha1:XSNFJXOPBN2DRP26UNT7WKG54TV6K3UP\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-17/CC-MAIN-2021-17_segments_1618038057476.6_warc_CC-MAIN-20210410181215-20210410211215-00240.warc.gz\"}"}