How do i turn the spreadsheet into a formula page?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sameeha - 07 Mar 2005 22:33 GMT

I had to make a spreadsheet for a sales budget for my accounting course and
my professor wanted us to show him the spreadsheet in a formula form ...such
as ... =d4*c5 something like that....now the problem is that i dont kno what
button to push to make the spreadsheet turn into formulas like that one i jus
showed....can someone please help me??/.....is that enough info gord dibben??

Reply to this Message

Gordon - 07 Mar 2005 22:42 GMT

|| I had to make a spreadsheet for a sales budget for my accounting
|| course and my professor wanted us to show him the spreadsheet in a
|| formula form ...such as ... =d4*c5 something like that....now the
|| problem is that i dont kno what button to push to make the
|| spreadsheet turn into formulas like that one i jus showed....can
|| someone please help me??/.....is that enough info gord dibben??

Did you actually try typing "display formulas" in Excel Help?
Of course not! Why should you? You're only a STUDENT!
Try a bit of RESEARCH first.

Signature

Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Reply to this Message

gls858 - 07 Mar 2005 22:42 GMT

> I had to make a spreadsheet for a sales budget for my accounting course and
> my professor wanted us to show him the spreadsheet in a formula form ...such
> as ... =d4*c5 something like that....now the problem is that i dont kno what
> button to push to make the spreadsheet turn into formulas like that one i jus
> showed....can someone please help me??/.....is that enough info gord dibben??

Ctrl + ~

Reply to this Message

sameeha - 07 Mar 2005 23:13 GMT

> Ctrl + ~

How do it do that though? do i highlight the whole spreadsheet and then push
those buttons or ???..... because i tried it and the numbers are turning into
#### those signs.... i dont know ??...help please

Reply to this Message

Gordon - 07 Mar 2005 23:18 GMT

||| Ctrl + ~
||
|| How do it do that though? do i highlight the whole spreadsheet and
|| then push those buttons or ???..... because i tried it and the
|| numbers are turning into #### those signs.... i dont know ??...help
|| please

Sheeesh! Try Tools-Options and on the View tab check the "Formulas"
box......and do some research first. You're supposed to be LEARNING Excel,
remember?

Signature

Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Reply to this Message

Ken Wright - 07 Mar 2005 23:20 GMT

Try Tools / Options / 'View' Tab / Tick formulas - Hit OK.

To reverse it, just repeat and untick.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> > Ctrl + ~
>
> How do it do that though? do i highlight the whole spreadsheet and then push
> those buttons or ???..... because i tried it and the numbers are turning into
> #### those signs.... i dont know ??...help please

Reply to this Message

Lady Layla - 10 Mar 2005 18:09 GMT

Have you tried expanding the size of the columns to show the formula?

: > Ctrl + ~
:
: How do it do that though? do i highlight the whole spreadsheet and then push
: those buttons or ???..... because i tried it and the numbers are turning into
: #### those signs.... i dont know ??...help please

Reply to this Message