On the formulas tab, in the Formula Auditing, click on the Show Formulas icon to see for formulas view. Click again to return to normal view.
Excel 2007: From the Formulas menu ribbon, in the Formula Auditing section, click on Show Formulas.
values version
formulas version
Click on the cell to view the formula in the formula bar at the top of the screen. If you would like to display the formula as text in a cell, instead of seeing the results of the formula, enter an apostrophe (') in front of the equal sign (=) of the formula. That will tell Excel to display the cell contents as text and not try to calculate the formula.
Press Ctrl + ` to toggle between formula mode and result mode.
Excel 2007: From the Formulas menu ribbon, in the Formula Auditing section, click on Show Formulas.
values version
values version
An Excel worksheet or spreadsheet allows data to be easily summed and charted.
worksheet
On the Toolbar click "Help". Type "Display or hide formulas" Find :Switch between displaying formulas and their values on a worksheetPress CTRL + ` (grave accent).
It allows you to split the window into two separate panes, aligned horizontally. This allows you to see two different areas of the worksheet at the same time. It can be accessed from the menus or dragged on and off the worksheet from the end of the scrollbar.
worksheet
It allows you to view different parts of a worksheet at the same time.
The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.The Zoom allows you to make the worksheet looking larger or smaller by apparently bringing it nearer or further, known as zooming in or out.
input device
split windows
You can use a facility called Goal Seek to try to establish a value in one cell that will produce a specific result for a formula in another cell.