If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
just need to display formulas nothing appears
I am a student and it says to display the cell formulas in the worksheet. I
have tried EVERYTHING and can't figure it out??? Please help |
#2
|
|||
|
|||
just need to display formulas nothing appears
EXCEL 2007
Take the following actions:- 1. Click in one cell in the Worksheet where you wish to display the formulas. 2. Hit the F5 key. 3. Hit Special . . . - in lower left hand corner 4. Formulas. 5. OK. All of the formulas in your Worksheet should now be displayed (it is not very clear they are just highlighted in a light grey colour so be careful you don't miss it). If my comments have helped please hit Yes. Thanks. "Sissy81" wrote: I am a student and it says to display the cell formulas in the worksheet. I have tried EVERYTHING and can't figure it out??? Please help |
#3
|
|||
|
|||
just need to display formulas nothing appears
On 20 Feb, 07:27, Sissy81 wrote:
I am a student and it says to display the cell formulas in the worksheet. I have tried EVERYTHING and can't figure it out??? Please help You want to display the formulas in the cells? Pressing Ctrl + ` (grave accent) seems to work in Excel 2003 and 2007. Some older web pages seem to suggest Ctrl + ~ (tilde). I wonder if this is for versions older than 2003. In 2007, there is also a 'Show Formulas' click button in the Formulas tab. |
#4
|
|||
|
|||
just need to display formulas nothing appears
CTRL + `(backquote above Tab key) to toggle view formulas on/off.
Gord Dibben MS Excel MVP On Fri, 19 Feb 2010 21:27:01 -0800, Sissy81 wrote: I am a student and it says to display the cell formulas in the worksheet. I have tried EVERYTHING and can't figure it out??? Please help |
Thread Tools | |
Display Modes | |
|
|