Where can i find the "Display Formulas" on excel?

M

Micah

Im working on an excel Assignment for college Spreadsheets one of the tasks
is to make sure all formulas are exposed "Visable" I can find the button or
icon to make them exposed? PLEASE HELP!
 
M

Mike H

Hi,

2 ways

Ctrl+`
The ` is to the left of the 1 key

or
Tools|Options - View tab
Check 'Formulas

Mike
 
S

Sheeloo

Press ' to make formulae visible, press again to hide. It is a toggle key...

It is located on top left of the keyboard (same key as ~)
 
G

Gord Dibben

Sheelo

Typo patrol............make that CTRL + ` to toggle view on/off


Gord Dibben MS Excel MVP
 
S

Sheeloo

:-(

Officer, let me go this time... I will not do this again...

Somehow I always mess this up...
 

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

Excel - Wich Function should I use? 1
Program buttons to create a word document 0
Finding asymptote equation and how to draw them in excel 0
Show week number in Project Report 0
Setting language of a selected text in Office apps. 0
Outlook - Catgorizing emails by names 0
Confusion over where user templates are stored in Word 1
Insert multiple objects at once ? 3

Top