excel training course - linking data

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Linking data

excel training course - Linking data

resolvedResolved · Low Priority · Version Standard

Tim has attended:
Excel Intermediate course

Linking data

what is the best way to link data between work sheets?

RE: Linking data

Hi Tim,

Thanks for the question

THe best way to link worksheets is to press the equals sign (=) and navigate to the other worksheet and click on the cell with the data in it. Thereby creating a link between the sheets. If you then went into the sheet that you have put the link in it will ask you whether you want to updata or not update the link.

I hope that helps

Tracy


 

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Server loaded in 0.14 secs.