Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Formula

excel training courses - Formula

ResolvedVersion Standard

Thu 28 Jun 2007, 12:43 Delegate Anna said...

Anna has attended:
Excel Intermediate course
Excel Advanced course

Formula

How do i view the formula only?

Fri 29 Jun 2007, 10:32 Trainer Tracy said...

RE: formula

Hi Anna,

Thanks for the question.

There are two ways, you can use the menu and go to Tools>Options>View tab and tick against the Formula box. Alternatively you can hold down the Control button and the button to the left of the number 1 on your keyboard and that will switch the formulas on or off.

Let me know if that works!!

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

excel training courses - Formula

Formula

RE: formula

Excel articles

Excel tip:

Make macros work in newer versions of Excel