Forum home » Delegate support and help forum » Microsoft Excel Training and help » Links between pages

Links between pages

ResolvedVersion 2003

Wed 10 Mar 2010, 16:32 Delegate Jude said...

Jude has attended:
Excel Introduction course

Links between pages

could you re-cap linking between pages please

Thu 11 Mar 2010, 10:59 Trainer Simon said...

RE: links between pages

Hi Jude,

Thank you for your question. Use a blank workbook for this example.

Select Sheet 2 cell A1 and click the equals button. Switch to Sheet 1 and select cell A1. Finally press enter to complete the formula.

So if you click into cell A1 of Sheet 2 the formula bar would read:

=Sheet1!A1

I hope this answers your question.

Regards

Simon

Wed 17 Mar 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Links between pages

Links between pages

RE: links between pages

Excel articles

Excel tip:

Use shortcut keys to select rows or columns