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

linking

ResolvedVersion 2010

James has attended:
Excel Intermediate course
Excel Advanced course

Linking

how do you link workbooks

RE: linking

you can link workbooks just like you would create a basic formula.

A simple way to link a workbook is to select a cell in one workbook, enter =, then click into the cell in the second workbook. These cells will now be linked. Try it.

Thu 19 Jan 2012: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.