Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training course - Linking data

Resolved · Low Priority · Version Standard

Reply Tue 26 Jun 2007, 16:34Delegate Tim said...

Tim has attended:
Excel Intermediate course

Linking data

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

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Jun 2007, 10:26Trainer Tracy said...

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 articles

· A Quick Guide To Conditional Formatting In Excel 2007/2010
· Learn The Secrets Of COUNT Functions In Excel
· Excel in the Home Office
· Update Your VAT Rates In Excel
· How To Disguise Error Messages In Excel 2007/2010

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips