Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course london - EXCEL

excel course london - EXCEL

ResolvedVersion Standard

Mon 4 Jun 2007, 16:38 Delegate Rita said...

Rita has attended:
Excel Advanced course

EXCEL

I m having trouble copying and pasting formulas from one cell to another in the same spreadsheet, the cell recognises the correct formula with the correct input cells, but returns the original value, not the formula value. this seems to happening to all my excel worksheets - pls help!

Tue 5 Jun 2007, 12:33 Trainer Amanda said...

RE: EXCEL

Hi Rita

Thanks for your question - this is an interesting one!

Can you check to see if your formulas are set to calculate manually? Go to Tools - Options - Calculation and see if Calculation has been sent to Manual. If this is the case, you can change it back to manual, in which case formulas should recalculate their results automatically again.

If this is not the problem, let me know.

Amanda

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

excel course london - EXCEL

EXCEL

RE: EXCEL

Excel articles

Excel tip:

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