2002 excel microsoft training - Spreadsheets

Resolved · Low Priority · Version 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:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

2002 excel microsoft training - Spreadsheets

Spreadsheets

RE: Spreadsheets

Excel articles

Excel tip:

Bracketed negative numbers