[Archived] Help Desperatley Needed!

[SYRovers]

Does anyone know how to change the sheet so it shows all of the formula's??

Any help or guidance would be much appreciated!

[AussieinUk]

Under header click Tools, options then on the view tab, check formulas option.

[SYRovers]

i have the new version and cant quite see the 'Tools' tab...where might that be?

Sorry for being such a plank but Excel gets the better of me every time!

[American]

I think the new one just has a View tab - if nothing else, go to the Excel help section.

[AussieinUk]

i have the new version and cant quite see the 'Tools' tab...where might that be?

Sorry for being such a plank but Excel gets the better of me every time!

Sorry I always use the 03 version.. cant stand the new interface.

There should be a check box for 'formulas' under view, as American has mentioned above

[SYRovers]

Ok I am sorted now.

Thanks to the both of you for your help!!!

[broadsword]

I think there's a keyboard short-cut for this so you can toggle it on and off eaisly, can't remember what it is though.

[LeChuck]

Pretty sure it's Alt + F4.

[broadsword]

That's close workbook I think.

It might be control + backquote `