Show Formulas or Print Formulas

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

Is there a way, and I believe there is but I cannot remember it, to show the
formulas in the cells instead of the values?
 
G

Gord Dibben

Hit CRTL +`(above TAB key) to toggle "View Formulas" on/off.

Gord Dibben Excel MVP
 
B

Bob Phillips

Use the Ctrl-` key combination (the ` is to the left of the numbers on the
keyboard).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0
Show a cell's formula in text format in a linked cell 2
3 IFs argument in one formula 2
Cannot access to Office Insider 0
Use TODAY() function as the criteria in a SUMIF formula 1
Office Word JPEG in a document showing but not printing out 0
need help in creating a formula 1

Top