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

excel course london - Formulas

ResolvedVersion Standard

Tue 6 Feb 2007, 09:43 Delegate Sarah said...

Sarah has attended:
Excel Intermediate course

Formulas

How can I use formulas on a new sheet relating to previous sheets ie. adding numbers cell from previous sheets?

Tue 6 Feb 2007, 11:11 Trainer Richard said...

RE: Formulas

To add cells on different sheets you would use a formula like:

=A1+Sheet2!B1

Where "Sheet2" is the name of the worksheet
Separated with a ! from the cell reference

Simply create the formual like you normally would, but click on the relevant sheets and cells as you create the formula

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

excel course london - Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Shortcut for deleting all comments in a spreadsheet