Add Inline Comments in Excel Labs or Advanced Formula Environment
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.

- 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.
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.
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.
In Excel, go to Home > Add-ins > Excel Labs, then select Advanced Formula Environment.
Click the Grid tab in the Advanced Formula Environment pane and select the name or formula you want to inspect.
Enter a slash-based comment next to a formula in the Grid tab and check whether it remains visible after editing.
Document Formulas with Meaningful LET Names or a Text Note
Use this workaround to keep formula documentation inside the formula itself when inline comments are not preserved.
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. Download and install WPS Office: Go to the WPS Office download page and install WPS Spreadsheets on your device.
- 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx file that contains your formulas.
- 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.

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.





