basic training excel - links
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Links

basic training excel - Links

resolvedResolved · Low Priority · Version Standard

replyReply Tue 19 Dec 2006, 17:05Delegate Jo said...

Jo has attended:
Excel Intermediate course

Links

how do i link workbooks

For upcoming training course dates see: Pricing & availability

replyReply Wed 20 Dec 2006, 09:54Trainer David said...

RE: links

Hi Jo

When you have both workbooks open, click in the cell in the main workbook (where you want the linked data to apear) within that cell, type an equals sign (=) and in the 2nd workbook, click the on the cell that you want to link to. THis will link the cell in the 2nd workbook to the one in the first workbook.

Hope this helps
David

 

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard