Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,805
Default 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!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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!


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,805
Default 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!





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How do I change the column heading in Excel to display "A" "B" "C Thai New Users to Excel 1 November 30th 07 08:06 PM
How to change the default in Excel from "find next" to "find all" igs Excel Discussion (Misc queries) 0 November 27th 06 06:20 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
How do I write "Either / Or" Display Formulas? Cleso Excel Discussion (Misc queries) 4 January 23rd 06 12:20 AM


All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"