Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return the "name box" to the tool bar.
The "name box" disappeared from the tool bar. The name box is ususally on
the left end of the format tool bar. It allows the user to view the underlining formulas etc. as opposed to the data or answer displayed in the cell. |
#2
|
|||
|
|||
One way:
Tools/Customize. In the Toolbars pane, select Formatting toolbar (e.g., "Formatting" highlighted, not just the checkbox checked). Click Reset. In article , ^mike^ wrote: The "name box" disappeared from the tool bar. The name box is ususally on the left end of the format tool bar. It allows the user to view the underlining formulas etc. as opposed to the data or answer displayed in the cell. |
#3
|
|||
|
|||
Hi, Thanks for the help, but thr name box did not reappear. Font and size
drop downs but not my name box. "JE McGimpsey" wrote: One way: Tools/Customize. In the Toolbars pane, select Formatting toolbar (e.g., "Formatting" highlighted, not just the checkbox checked). Click Reset. In article , ^mike^ wrote: The "name box" disappeared from the tool bar. The name box is ususally on the left end of the format tool bar. It allows the user to view the underlining formulas etc. as opposed to the data or answer displayed in the cell. |
#4
|
|||
|
|||
Mike
The "name box" does not display the formula in a cell. The Formula bar is what you are looking for. It has the name box(for showing names) at the left end. Go to ViewFormula Bar and check it. Gord Dibben Excel MVP On Wed, 15 Jun 2005 07:46:02 -0700, ^mike^ wrote: Hi, Thanks for the help, but thr name box did not reappear. Font and size drop downs but not my name box. "JE McGimpsey" wrote: One way: Tools/Customize. In the Toolbars pane, select Formatting toolbar (e.g., "Formatting" highlighted, not just the checkbox checked). Click Reset. In article , ^mike^ wrote: The "name box" disappeared from the tool bar. The name box is ususally on the left end of the format tool bar. It allows the user to view the underlining formulas etc. as opposed to the data or answer displayed in the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Free Data Process/Query Tool | New Users to Excel | |||
Free Data Process/Query Tool | Excel Discussion (Misc queries) | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions |