Tools Menu /text/scalc/00/00000406.xhp

Tools Menu

Choose Tools - Detective.

Choose Tools - Detective - Trace Precedents. Shift+F9

Menu Tools - Language - Hyphenation. Choose Tools - Detective - Remove Precedents.

Choose Tools - Detective - Trace Dependents. Shift+F5

Choose Tools - Detective - Remove Dependents. Choose Tools - Detective - Remove All Traces. Choose Tools - Detective - Trace Error. Choose Tools - Detective - Fill Mode. Choose Tools - Detective - Mark Invalid Data. Choose Tools - Detective - Refresh Traces. Choose Tools - Detective - AutoRefresh. Choose Tools - Goal Seek. Choose Tools - Solver. Choose Tools - Solver, click Options button. Choose Tools - Scenarios. Choose Tools - Forms. Choose Tools - Share Spreadsheet Choose Tools - Protect Sheet. Choose Tools - Protect Spreadsheet Structure.

Choose Data - Calculate - Recalculate. Press F9

Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Formula.

Choose Data - Calculate - Recalculate hard. Press Shift+CommandCtrl+F9

Select a formula cell or a formula cell range and choose Data - Calculate - Formula to values

Choose Data - Calculate - AutoCalculate. Choose Tools - AutoInput.