ExcelBanter - HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET (https://www.excelbanter.com/excel-worksheet-functions/95255-how-do-i-display-formula-contents-spreadsheet.html)

Vanessa

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?

Ian P

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?

Alok

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?

All times are GMT +1. The time now is 11:51 AM.