Anybody good with excel?

[Sophie123]

Ive completely forgotten how to make it so that the formulas are displayed, rather than the answer to the formulas.

Any help?

Rep awarded!

[EDWARDS]

nah im not very good with it

just thought id let you know

[Sophie123]

thanks for that.
Got my hopes up.

neg repped for the pointlesness of that post.

[matt_vtr_15]

CTRL F4 immediately followed by CTRL F11

hope that helps ;)

[Sophie123]

Your not trying to make me crash my computer are you???
Because that would be really mean as i have a 5pm deadline for this work!

[matt_vtr_15]

Your not trying to make me crash my computer are you???
Because that would be really mean as i have a 5pm deadline for this work!

no seriously

[DevilDamo]

How about...

(Select cell) => Format => Cells => (Number tab) => Text

You have to set the cells format before entering the information.

[Sophie123]

It took me to a blank page???

[Pat_Vts]

type ''i love pat_vts''

all forumlas automatically do it themselves;)

[Sophie123]

How about...

(Select cell) => Format => Cells => (Number tab) => Text

You have to set the cells format before entering the information.

eh???
im pretty sure there is a way of switching between the two, i need a print off of the formula's and a print off of the actual answers....

[Sophie123]

type ''i love pat_vts''

all forumlas automatically do it themselves;)

Formulas are done, i just need them to show when i print it :wall:

[DevilDamo]

Ok then. How about...

Press CTRL + ` (grave accent)

[Sophie123]

Ok then. How about...

What? lol

[matt_vtr_15]

just did this one myself and it worked

CTRL F6

hope it helps

[DevilDamo]

Read above!

[Sophie123]

just did this one myself and it worked

CTRL F6

hope it helps

Nothing :(

[matt_vtr_15]

here sophie,

this should help :)

http://www.dslimited.biz/excel_tutorials/findformulas.html

[Dr_Lee]

Its already been said:

Press: Ctrl+ '

or Formulas -> show formulas

http://i164.photobucket.com/albums/u21/leequelch_photos/Untitled-1-1.jpg

[evans1089]

i know alot about it, did 2 years on it making systems etc...
pm me if you have any questions ;)

[Sophie123]

here sophie,

this should help :)

http://www.dslimited.biz/excel_tutorials/findformulas.html

Lifesaver!!!!
Thanks sooo much.

Tried to rep but have to spread it =[

[leesaxo1000cc]

ctrl + `

[saxodan]

shit me
girls are thick as fuck

[matt_vtr_15]

Lifesaver!!!!
Thanks sooo much.

Tried to rep but have to spread it =[

no problem :)

:hug:

[Sophie123]

Whoever negged me could have left your name :n:

Also, im not thick, just forgot, my brain is a bit overloaded at the moment.

[matt_vtr_15]

Whoever negged me could have left your name :n:

Also, im not thick, just forgot, my brain is a bit overloaded at the moment.

wouldn't worry,

plenty of cocks neg rep on here and leave no name... infact about 5 in the last week for me iirc....

i didnt neg you i have spread too much green from my doggy thread in the last 24 hours...

[djrem]

shit me
girls are thick as fuck

i lold.

i just press '


as in the button to the right of L and Semi-colon

[evans1089]

what you using excel for anyway sophie?
accounts or something?

[Sophie123]

Well i am doing an accounts degree, but this essay is about analysing quantitive data.
have to analyse things using farious correlation techniques, but it all has to be done using formulas instead of worked out in my head, hence why i have to print it twich showing formula and answers :y:

[evans1089]

cool, we had to make a system based on solving a problem for a company, how to analyse their profits etc and how they can use the information we gave them. quite simple, but yours sounds interesting :P

[matt_vtr_15]

fuck off neg repping leaving no name.

just leave your name ffs. infact next time i get neg rep with a name i will give them pos rep just for being honest...

[saxodan]

fuck off neg repping leaving no name.

just leave your name ffs. infact next time i get neg rep with a name i will give them pos rep just for being honest...

thanks mate
just left you some bad with my name

postive much appreciated
regards
saxodan

[Sophie123]

cool, we had to make a system based on solving a problem for a company, how to analyse their profits etc and how they can use the information we gave them. quite simple, but yours sounds interesting :P

ohh its really not inteeresting in the slightest!
Its made up data about how much students spend on food and drink.
then i have to work out using correlation techiques such as Pearsons's correlation coefficient r, and Spearman rank correlation coefficient if they are in any way related.

yawn.

[matt_vtr_15]

thanks mate
just left you some bad with my name

postive much appreciated
regards
saxodan

so you have,

can't give rep yet though

[djrem]

fuck off neg repping leaving no name.

just leave your name ffs. infact next time i get neg rep with a name i will give them pos rep just for being honest...

that was supposed to be neg rep...

[leesaxo1000cc]

Well i am doing an accounts degree, but this essay is about analysing quantitive data.
have to analyse things using farious correlation techniques, but it all has to be done using formulas instead of worked out in my head, hence why i have to print it twich showing formula and answers :y:
come on, we all know you used those long words to disguise the fact you had forgotten a simple procedure :P

[evans1089]

ohh its really not inteeresting in the slightest!
Its made up data about how much students spend on food and drink.
then i have to work out using correlation techiques such as Pearsons's correlation coefficient r, and Spearman rank correlation coefficient if they are in any way related.

yawn.

lool! well i live next door to my old IT teacher who is now a deputy head of my old school and head on the IT department! if you need any info on anything pm me, i'll go nip next door and ask him then reply to you ;)

might save you a bit of time haha lol

[hellonpluto]

Press CTRL + ` (grave accent).

[Robb]

thanks mate
just left you some bad with my name

postive much appreciated
regards
saxodan

hahaha legend.

i always leave your name when i neg rep too funnily enough.