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

excel training - Formulars

ResolvedVersion Standard

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

Lesley has attended:
Excel Introduction course
Excel Intermediate course

Formulars

whats the keyboard comand to show formulars

Mon 10 Dec 2007, 13:08 Trainer Carlos said...

RE: formulars

Lesley

To show formulas on the active worksheet:

1. Select the worksheet where the formulas are
2. Hold down the "Ctrl" key and press the key to the left of the "1" key on the keyboard.

All the formulas on the worksheet appear.

Repeat the process to hide the formulas

Hope it helps

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel training - Formulars

Formulars

RE: formulars

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines