Forum home » Delegate support and help forum » Microsoft Excel Training and help » Budget spreadsheets and formulas

Budget spreadsheets and formulas

ResolvedVersion 2003

Mon 1 Sep 2008, 15:49 Delegate Sophie said...

Sophie has attended:
Excel Intermediate course

Budget spreadsheets and formulas

What should I do if text or numbers appear in red on a budget spreadsheet indicating an error?

Tue 9 Sep 2008, 15:56 Trainer David said...

RE: Budget spreadsheets and formulas

The spreadsheet you are working with must have VBA coding or conditional formatting. I would check in with who created it. Alternatively you can change the conditional format by clicking in the cell that went red and clicking format/conditional format/Delete

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Budget spreadsheets and formulas

Budget spreadsheets and formulas

RE: Budget spreadsheets and formulas

Excel articles

Excel tip:

Sorting data stored in rows