Conteúdo

# Recalcular

Recalculates formula cells.

Para aceder a este comando...

#### Na barra de menus:

Choose Data - Calculate - Recalculate.

#### A partir da interface com separadores:

Choose Data - Recalculate.

On the Data menu of the Data tab, choose Recalculate.

#### Nas barras de ferramentas:

Recalculate

#### Do teclado:

F9

If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them.

If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them.

In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.

Press F9 to recalculate. Press Shift+Command Ctrl+F9 to recalculate all formulas in the document, including Add-In functions and non-volatile functions.

Depois de recalcular o documento, a exibição é atualizada. Todos os gráficos são recarregados.

Tópicos relacionados

Recalculation options

Calculate

Necessitamos da sua ajuda!