MS Excel..

[EvilDoc]

How can i make excel show all formulas?

 

[Kernow]

Try ctrl-~ (next to the z key).

 

[EvilDoc]

~ that key is no where near the z key 😀

 

[Applespider]

~ that key is no where near the z key 😀

It is on a UK keyboard - it's right next to it 😉

 

[Kernow]

~ that key is no where near the z key 😀

Ah - probably the UK keyboard 🙂

Did it work though?

Edit: - Applespider beat me to it.

 

[EvilDoc]

no it changed the format , did let me see the cells though

on a side note i didnt know the layout of the keys was diffrent in the UK

 

[Applespider]

Do you mean show all the formulas available to you? (guessing not, since that's just pushing the fx in the toolbar?

Or to see the formula in the cell rather than the result? If so, Kernow's shortcut is right.

 

[EvilDoc]

ok that did it, i dont know why it didt work the 1st time, i think i was had a cell selected.. thanks a bunch

 

[EvilDoc]

I got another question!! in Winxp in Excel you can selected more then one cell by holding ctrl, how do you do it in osx?? example, cell C9 and cell e21

If you couldnt tell i am kinda new to OSX.. again thanks for all the help

 

[Applespider]

You use the Command key like you would the Control key