<div class="raw-html-embed"> The Formula tab in the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)">Spreadsheet Editor</a> tab allows <a href="/docs/userguides/spreadsheet_editor/InsertFunction.aspx" onclick="onhyperlinkclick(this)">working easily with all functions</a>.
 <div class="onlineDocumentFeatures">
 The corresponding window of the Online Spreadsheet Editor:
 <img class="width-content" alt="Formula tab" src="https://static-helpcenter.teamlab.info/formulatab_8eef72e995.png">
 </div>
 <div class="desktopDocumentFeatures">
 The corresponding window of the Desktop Spreadsheet Editor:
 <img class="width-content" alt="Formula tab" src="https://static-helpcenter.teamlab.info/desktop_formulatab_0df267dbd6.png">
 </div>
 Using this tab, you can:
 <ul>
 <li>insert functions using the Insert Function dialog window,</li>
 <li>quickly access Autosum formulas,</li>
 <li>access 10 recently used formulas,</li>
 <li>work with formulas classified into categories,</li>
 <li>work with <a href="/docs/userguides/spreadsheet_editor/UseNamedRanges.aspx" onclick="onhyperlinkclick(this)">named ranges</a>,</li>
 <li>trace precedents and dependents,</li>
 <li>show formulas in the cells instead of the formula results,</li>
 <li>use the <a href="/docs/userguides/spreadsheet_editor/WatchWindow.aspx" onclick="onhyperlinkclick(this)">Watch Window</a>,</li>
 <li>use the calculation options: calculate the entire workbook, or the current worksheet only.</li>
 </ul></div>

Program interface

Spreadsheet Editor - Formula tab

Formula tab

Docs

Formula tab

Host ONLYOFFICE Docs on your own server or use it in the cloud