| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET
I have a spreadsheet with addition of several numbers in one cell. How can I
display these numbers and print them instead of the final value? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET
Try ToolsOptions and then select the View tab and tick the formulas box.
This will display the formula and not the result. Ian "Vanessa" wrote: I have a spreadsheet with addition of several numbers in one cell. How can I display these numbers and print them instead of the final value? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET
A keyboard short cut is Ctrl-~ (that is Control Tilde)
Alok Vanessa wrote: I have a spreadsheet with addition of several numbers in one cell. How can I display these numbers and print them instead of the final value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) | |||
| Adding the contents of a cell to a formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Linear Mode
