Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i turn the spreadsheet into a formula page?
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?? |
#2
|
|||
|
|||
sameeha wrote:
|| 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. -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#3
|
|||
|
|||
sameeha wrote:
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 + ~ |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
sameeha wrote:
||| 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? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#6
|
|||
|
|||
Try Tools / Options / 'View' Tab / Tick formulas - Hit OK.
To reverse it, just repeat and untick. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "sameeha" wrote in message ... 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 |
#7
|
|||
|
|||
Have you tried expanding the size of the columns to show the formula?
"sameeha" wrote in message ... : 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PRINT SPREADSHEET ON 1 PAGE LEGIBLY | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |