Quick Links ▼

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

excel 2003 training course - Linking workpages

Resolved · Low Priority · Version Standard

Reply Thu 15 Nov 2007, 17:03Delegate Bridget said...

Bridget has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Intermediate Advanced course

Linking workpages

Can you remind me how to link 2 different pages together

For upcoming training course dates see: Pricing & availability

Reply Sat 17 Nov 2007, 11:18Trainer Pete said...

RE: Linking workpages

Hi Bridget, Thanks for the post, to link pages and even workbooks you will need to create a formula which references both items, the simplest way to link is to place an equals (=) sign in the receiving worksheet, immediatly navigate to the source workbook/sheet and select the cell you wish to link to, press enter key and your worksheets are linked, any changes in the source will be updated in the receiving sheet. I hope that jogs the memory, regards Pete.

Excel articles

· Prepare for your MOS Certification with MS Excel Courses
· How To Use Vlookup In Excel
· How To Learn From Your Excel Mistakes
· How To Use Filtering In Excel 2010
· How To Take Your Data Out Of The Shade

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