Office Settings & Configuration

Add Inline Comments in Excel Labs or Advanced Formula Environment

Nimra MalikNimra Malik Nov 13, 2026 871 views

Question details

The user wants to know whether slash-based inline comments are supported in the Grid tab of Excel Labs or the Advanced Formula Environment and how to keep formula documentation intact.

Add Inline Comments in Excel Labs or Advanced Formula Environment
Product
Microsoft Excel Labs / Advanced Formula Environment
Device & OS
not provided
Scenario
The user is editing formulas in the Grid tab of Excel Labs or Advanced Formula Environment and wants to add inline comments using slash-based syntax.
Observed behavior
Inline comments may not be supported in the Grid tab, and comments can be removed when names synchronize with the workbook.
Before you start

Confirm your Microsoft 365 update channel and the installed Excel Labs/Advanced Formula Environment version, then review the official GitHub issue “Comments in the Grid tab” before testing inline comments.

Solution 1

Check Current Inline Comment Support in the Excel Labs Grid Tab

Use this first to confirm whether your Excel Labs build preserves slash-based comments in the Grid tab.

Excel Labs and the Advanced Formula Environment store names in the custom XML part of the workbook. When names are synchronized back to the spreadsheet, comments embedded in the Grid view are often stripped.

1
Open the Advanced Formula Environment add-in

In Excel, go to Home > Add-ins > Excel Labs, then select Advanced Formula Environment.

2
Switch to the Grid tab

Click the Grid tab in the Advanced Formula Environment pane and select the name or formula you want to inspect.

3
Test slash-based comment syntax

Enter a slash-based comment next to a formula in the Grid tab and check whether it remains visible after editing.

Support varies by build: Check the Microsoft Advanced Formula Environment GitHub issue “Comments in the Grid tab” for current support information.
Free Microsoft Office alternative

Use WPS Office Spreadsheets for Formula Notes and .xlsx Workbooks

WPS Office is a free, lightweight Microsoft Office alternative that opens and saves .xlsx workbooks with a familiar ribbon interface, so you can document formulas with built-in comments and notes without Excel Labs add-in sync issues.

  1. 1. Download and install WPS Office: Go to the WPS Office download page and install WPS Spreadsheets on your device.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx file that contains your formulas.
  3. 3. Add a comment or note: Select the formula cell, go to the Review tab, and click New Comment to attach a note that stays with the workbook.
Built-in cell comments and notes keep formula documentation visible while you edit.Full compatibility with .xlsx and other Microsoft Excel workbook formats.Free, lightweight Office suite with a familiar ribbon-based spreadsheet interface.Seamless migration from Microsoft Excel without losing formulas, formatting, or named ranges.No Excel Labs or Advanced Formula Environment add-in required for everyday formula documentation.
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel Labs Advanced Formula Environment support slash-based inline comments in the Grid tab?

Support is not consistent. In the Grid tab, inline comments may not be preserved, and comments can be removed when names are synchronized with the workbook. Check the Microsoft Advanced Formula Environment GitHub issue “Comments in the Grid tab” for your build.

Why do my comments disappear after syncing names to the workbook?

Advanced Formula Environment stores names in the custom XML part of the file. During synchronization, the add-in can strip comments that are not part of the underlying defined name content.

What is the LET workaround for adding formula notes?

Edit the formula in the formula bar and use meaningful LET names for inputs. You can also add an unused LET argument such as _note,"text" before the final calculation to keep a text note inside the formula.

Can WPS Office open workbooks that contain LET formulas?

WPS Office Spreadsheets opens and saves .xlsx files and includes comment and note tools. For workbooks that use newer functions such as LET, check the WPS version release notes for function support.

Is WPS Office a free alternative for Excel Labs workbooks?

WPS Office offers a free Spreadsheets app that can open Excel workbooks and add cell comments or notes without requiring the Excel Labs add-in. It maintains .xlsx compatibility and a familiar ribbon interface.