ExcelBanter - Calculate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculate (https://www.excelbanter.com/excel-worksheet-functions/249226-calculate.html)

Eva

Calculate

When I press F9 I would like to calculate only the data in one sheet not in
the whole book. How to do it?
--
Greatly appreciated
Eva

Niek Otten

Calculate

SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eva" wrote in message
...
When I press F9 I would like to calculate only the data in one sheet not
in
the whole book. How to do it?
--
Greatly appreciated
Eva

Teethless mama

Calculate

SHIFT F9 calculates the active worksheet. CTRL ALT F9 calculates all
worksheets in all open workbooks.

"Eva" wrote:

When I press F9 I would like to calculate only the data in one sheet not in
the whole book. How to do it?
--
Greatly appreciated
Eva

Eva

Calculate

Thank you for your response.
--
Greatly appreciated
Eva

"Teethless mama" wrote:

SHIFT F9 calculates the active worksheet. CTRL ALT F9 calculates all
worksheets in all open workbooks.

"Eva" wrote:

When I press F9 I would like to calculate only the data in one sheet not in
the whole book. How to do it?
--
Greatly appreciated
Eva

All times are GMT +1. The time now is 12:47 PM.