bullit
Tank Troll
+71|6690|London, UK
When you make a spreadsheet to see the formulas what do you press again, forgot

Cheers
liquidat0r
wtf.
+2,223|6628|UK
Don't know if there's a shortcut. But if you click the Office icon, then click Excel Options, then on the Advanced tab scroll down to "Display options for this worksheet"
Jenspm
penis
+1,716|6733|St. Andrews / Oslo

ctrl + J
https://static.bf2s.com/files/user/26774/flickricon.png https://twitter.com/phoenix/favicon.ico
Kurazoo
Pheasant Plucker
+440|6685|West Yorkshire, U.K

Jenspm wrote:

ctrl + J
No its alt+f4
utchin
Member
+8|5915
click on the logo, excel options , advanced and then scroll down.. dont know the short cut key
steelie34
pub hero!
+603|6382|the land of bourbon

Kurazoo wrote:

Jenspm wrote:

ctrl + J
No its alt+f4
fail
https://bf3s.com/sigs/36e1d9e36ae924048a933db90fb05bb247fe315e.png
bullit
Tank Troll
+71|6690|London, UK
hmmm ok just realised the computers in Uni don't have 2007 and seeing as some of you don't know the option to tick for 2007, what is it for 2003?

For 2007 its advanced>display options for worksheet>tick 'show formulas in cells'

I also pressed alt+f4 and it just deleted all my work

Last edited by bullit (2008-05-01 12:43:31)

utchin
Member
+8|5915
exaclty what i said, or go on the formulas tab and its on the right under faurmala auditing
Jenspm
penis
+1,716|6733|St. Andrews / Oslo

ctrl + j still works.
https://static.bf2s.com/files/user/26774/flickricon.png https://twitter.com/phoenix/favicon.ico
bullit
Tank Troll
+71|6690|London, UK

Jenspm wrote:

ctrl + j still works.
seriously doesn't lol
Dauntless
Admin
+2,249|6743|London

Formulas > Formula Auditing > Show Formulas

https://img146.imageshack.us/img146/1950/htresaq1.png
http://img146.imageshack.us/img146/1950/htresaq1.png
https://imgur.com/kXTNQ8D.png
AussieReaper
( ͡° ͜ʖ ͡°)
+5,761|6154|what

Kurazoo wrote:

Jenspm wrote:

ctrl + J
No its alt+f4

bullit wrote:

I also pressed alt+f4 and it just deleted all my work
ban.
https://i.imgur.com/maVpUMN.png
unnamednewbie13
Moderator
+2,053|6773|PNW

Office 2007 can kiss my ass. Dunno why they had to tweak out the interface.
pirana6
Go Cougs!
+682|6292|Washington St.
since nobody has answered correctly:

it's ctrl + ` (the botton under esc and above tab)

Board footer

Privacy Policy - © 2024 Jeff Minard