How to create an Excel formula in Notepad ++

Excel formulas, when done with complicated statistics and calculations, are often quite long, and you even have to combine many functions together, so the formula will be much longer.

If so, you can use Notepad ++ to edit formulas entered into Excel for easier viewing and making formulas easier. When entering Excel formulas in Notepad ++, there will be additional features of highlighting, highlighting and hinting.

The following article will guide you how to set up an Excel input formula in Notepad ++.

Instructions for making draft formulas in Excel

Step 1:

We download the Notepad ++ tool in the link below and install it on the computer as usual.

1. Download Notepad ++ software here

How to create an Excel formula in Notepad ++ Picture 1

Then you download 2 XML files to support editing formulas in Notepad ++, follow the link here.

Step 2:

Next, access the folder on your computer under the path C: Program Files (x86) Notepad ++ pluginsAPIs . Next, we will copy the 2 XML files loaded above into this directory.

How to create an Excel formula in Notepad ++ Picture 2

Step 3:

Open Notepad ++ software and then click on Language> User Defined Language and then select Define your language .

How to create an Excel formula in Notepad ++ Picture 3

Now displaying a new interface, we click the Import . button and then import the copied XLF UDL.xml file into the Notepad ++ APIs directory above.

How to create an Excel formula in Notepad ++ Picture 4

Step 4:

Finally, restart the Notepad ++ software and then click on Language and select XLF below the list displayed. Then just enter your Excel input formula.

How to create an Excel formula in Notepad ++ Picture 5

Jessica Tanner

Update 01 October 2020