Can you print out a page viewing the formulas only

[workingmom434]

I want to print a page showing the formulas as I have to create many spreadsheets using similiar formulas. Is there a way to print a page viewing formulas put in each cell?

[icestationzbra]

while you are viewing the page where you have entered formuale, click CTRL + ~ (tilde, which is the key to the left of ! / 1).

you will see that all the formulae have now become visible (instead of their output). you can now print this out as you would normally an Excel page.

[oeldere]

CTRL + T will show you the formula instead of the value.

Then you can print the sheet.

[workingmom434]

Thank you, it worked like a charm. I love this forum!

[oeldere]

Thanks for the reply.

Glad i could help.

If your question is solved, will you mark it as solved?

You can click on the star * if you liked the anser your given.

Then the responder will get point on his rep(utation).