| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I display cell formulas in Excel 2007
In previous versions of Excel, all cells could be made to display their
formulas but in 2007 I can find how to do that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I display cell formulas in Excel 2007
Press CTRL-`
It toggles between showing formulas and values... "pangracs" wrote: In previous versions of Excel, all cells could be made to display their formulas but in 2007 I can find how to do that. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I display cell formulas in Excel 2007
You may also select all cells, Open teh Formulas tab, and choose Show
Formulas from eth formula audint group. If you are displaying in smaller than full screen window you may not see that option, but it is there! "pangracs" wrote: In previous versions of Excel, all cells could be made to display their formulas but in 2007 I can find how to do that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display formulas in 2007 Excel spreadsheets? | Excel Discussion (Misc queries) | |||
| Display of Active Cell in MS Excel 2007 | Excel Discussion (Misc queries) | |||
| can I use 2 formulas in 1 cell and display both results | New Users to Excel | |||
| Why doen't PasteSpecial, Formulas not display formula in cell? | Excel Discussion (Misc queries) | |||
| display values of formulas in Excel | Excel Worksheet Functions | |||
Hybrid Mode
