How to create reusable formula in Excel?
Create reusable formulas helps you quickly use these formulas in Excel without repeatedly typing them every time you use. In this article, we will show you how to use the AutoText utility of Kutools for Excel for easily making formulas reusable by creating the formula as Auto Texts in Excel.
Recommended Excel Productivity Tools
After installing Kutools for Excel, please do as follows.
|Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.|
1. Click Kutools > Insert > AutoText. See screenshot:
2. In the worksheet, select the formula you want to make it reusable, and then click the New Autotext button.
3. In the New AutoText dialog box, type a name for this auto text entry in Name box, select Formulas in Group drop-down list, and then click the Add button. See screenshot:
4. Now the formula is added as a reusable auto text entry in the Formulas group in Autotext pane. Please get into the Formulas group in the AutoText pane, click the formula you have created to insert it into the worksheet.