Recalculation of formulas in automatic mode

General information

Hide or display the Favorites group

Formula bar

Files

Open a file

Save a file

Save as
Save

Autorecovery of documents

Close a file

Cells, columns, and rows

Data

Enter data

Sort and filter

Single-level sorting

Operations with lists and list items

Multi-level sorting

Filter

Notes

Special characters

Number formats

Currency

Accounting

Date, Time, and Date and time

Formulas and functions

Recalculation of formulas

Function wizard

Reference to data in another document

Structured references

Array formulas

Calculation operators

Tables

Pivot tables

Create a pivot table

Delete a pivot table field

Customize the pivot table parameters

Manage external sources

Filter data in a pivot table

Charts

Images

Insert an image

Shapes

Outline

Line style

Format

Copy and apply formatting

Clear formatting

Edit content

Clipboard history

Change paste parameters

Cloud actions

Automation tools

Macros

Macros in Lua

Macros in VBA

Extensions

Document protection

Protect document with a password

Protect content from changes

Financial functions

Date and time functions

Math and trig functions

Statistical functions

Lookup and reference functions

Database functions

DSUM

Text functions

Logical functions

Information functions

Engineering functions

Additional information

Feedback

Application: Spreadsheet Education

In automatic mode, only outdated formula values are recalculated when opening a document. If you want to force calculate all formulas in the document, press Ctrl+Shift+F9.

Share:

Was this helpful?

Yes

No