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

excel 2003 training course - linking workpages

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

excel 2003 training course - Linking workpages

ResolvedVersion Standard

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

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 tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.