excel training course - Formulas

Resolved · Low Priority · Version Standard

Mon 10 Dec 2007, 12:53 Delegate Sally said...

Sally has attended:
Word Introduction course
Outlook Introduction course
Excel Introduction course
PowerPoint Introduction course

Formulas

How do you show the formulas you are using on a particular spreadsheet?

Thu 13 Dec 2007, 16:39 Trainer Pete said...

RE: Formulas

Hi Sally, Thank you for your post, Sorry for the delay in responding, in answer to your question; To display the formulas quickly you can use the Toggle keyboard combination CTRL+

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

excel training course - Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command