Consequently, you can find and edit the spreadsheet cells more effectively. Now you’ll find that the spreadsheet displays all the formulas in its cells instead of their values as below.
:max_bytes(150000):strip_icc()/how-to-use-absolute-cell-reference-in-excel-4692257-2-265feb3ef1b54364acdfb8f5b01d8a97.png "openoffice calc reference cell in another sheet")
Click OK to close the window and return to the spreadsheet. There you should select the Formulas check-box. That includes various display settings for the spreadsheet. Then you should select Calc, and click on View to open the window in the shot below. Click Tools and Options to open the OpenOffice options window. However, you can display all the formulas in the spreadsheet instead of their values. The shortcut key merely displays the formula within a selected cell. That displays the cell’s formula as in the shot below. Open a spreadsheet with a variety of formulas in it, select a cell which includes a formula and press F2. However, there are a couple of ways you can display the cell formulas instead of their numerical values.įirstly, there is a shortcut key that displays selected spreadsheet cell formulas. As such, the formulas you put in the spreadsheet are not entirely visible. OpenOffice spreadsheets display cell formula values by default.
0 kommentar(er)
