ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Where can i find the "Display Formulas" on excel? (https://www.excelbanter.com/excel-worksheet-functions/208465-where-can-i-find-display-formulas-excel.html)

micah

Where can i find the "Display Formulas" on excel?
 
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!

Mike H

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

2 ways

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

or
Tools|Options - View tab
Check 'Formulas

Mike

"Micah" wrote:

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!


Sheeloo[_3_]

Where can i find the "Display Formulas" on excel?
 
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 ~)

"Micah" wrote:

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!


Gord Dibben

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

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


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 14:10:22 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:

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 ~)

"Micah" wrote:

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!



Sheeloo[_3_]

Where can i find the "Display Formulas" on excel?
 
:-(

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

Somehow I always mess this up...


"Gord Dibben" wrote:

Sheelo

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


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 14:10:22 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:

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 ~)

"Micah" wrote:

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!




Gord Dibben

Where can i find the "Display Formulas" on excel?
 
On Thu, 30 Oct 2008 16:11:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:

I will not do this again...


Never say never

I'm speaking from experience<g


Gord




All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com