Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Workbook

excel in courses - Workbook

ResolvedVersion Standard

Mon 4 Jun 2007, 16:34 Delegate muriel said...

muriel has attended:
No courses

Workbook

how do I link a workbook

Wed 6 Jun 2007, 11:39 Trainer Tracy said...

RE: workbook

Hi Muriel,

Thanks for the question.

You can link a worksheet to another worksheet by simply pressing the equals sign and locating a different workbook with your cursor and pressing enter. By doing that you create a link between the two workbooks, if the figure in one changes the link is updated in the source.

Hope that helps

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel in courses - Workbook

Workbook

RE: workbook

Excel articles

Excel tip:

Sorting data stored in rows