Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Spreadsheets

2002 excel microsoft training - Spreadsheets

ResolvedVersion Standard

Mon 12 Mar 2007, 16:14 Delegate Anna said...

Anna has attended:
Excel Introduction course
Excel Intermediate course

Spreadsheets

How do I create a link between spreadsheets

Mon 12 Mar 2007, 16:25 Trainer Richard said...

RE: Spreadsheets

By simply adding the relevant cells to the formula.

=A1+Sheet2!B1

This will link cell B1 from Sheet 2 to Cell A1 in the current sheet, and then add the two together.

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

2002 excel microsoft training - Spreadsheets

Spreadsheets

RE: Spreadsheets

Excel articles

Excel tip:

Number format shortcut