+ Reply to Thread
Results 1 to 1 of 1

FormulaBeautifyXL Add-in: Parse Excel formulas into a tree for easy editing

  1. #1
    Registered User
    Join Date
    04-18-2021
    Location
    Nha Trang, Vietnam
    MS-Off Ver
    2019
    Posts
    2

    FormulaBeautifyXL Add-in: Parse Excel formulas into a tree for easy editing

    (I'm Vietnamese - I used Google Translate)

    Today I share with you the Add-in Parse Formulas into Trees for Easy Formula Editing .
    Many of your Excel applications may have very long formulas, when we make formula editing, our eyes see and shape the formula, it is very difficult, so we need a tree part to simplify the work. editing, so I wrote this Add-in to help you simply edit Excel formulas.

    Usage is very simple:


    For example, we have the formula in cell C6 as:
    =IF(SUM(IF("FOO"="BAR",10,0),10)=20,"FOO","BAR")
    When double-clicking on cell C6
    The formula will be parsed as shown below, returned right at that formula cell.


    Name:  Untitled.jpg
Views: 43
Size:  12.6 KB

    After pressing Enter or Ctrl+Shift+Enter to execute the formula, if there is a warning as shown below, then type a Space at the beginning of the formula before the "=" sign, to " =" and press Enter or Ctrl +Shift+Enter .

    Name:  alert_8192_chars.jpg
Views: 43
Size:  14.4 KB



    Shortcut: Ctrl+Alt+C to Allow Formula Analysis to work or pause
    (Default shortcut is Ctrl+Alt+C, you can change it to your desired shortcut, ^ is Ctrl , + is Shift and % is Alt)


    Download the Add-in below and install the Add-in or copy it to the startup XLStart folder of the Excel application.

    The add-in is the first version, so there may be errors, so please consider using it, or you can comment below.
    Attached Files Attached Files
    Last edited by SanbiVN; 05-07-2022 at 02:22 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 10-27-2015, 06:49 PM
  2. [SOLVED] Parse internet explorer tree structure via vba.
    By Lloyd Blankfein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-08-2013, 07:40 AM
  3. Editing conditional formulas in Excel 2003
    By egildone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2012, 04:02 AM
  4. Excel 2007 : Editing Formulas in Excel '07
    By honestabe1982 in forum Excel General
    Replies: 2
    Last Post: 11-18-2010, 05:24 PM
  5. Inserting/Editing Formulas in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-13-2007, 06:53 AM
  6. Replies: 2
    Last Post: 12-09-2005, 01:40 PM
  7. Easy way to parse...
    By Diane in forum Excel General
    Replies: 2
    Last Post: 03-23-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1