Forum home » Delegate support and help forum » Microsoft Excel Training and help » Introduction Excel

Introduction Excel

ResolvedVersion 2003

Thu 20 Nov 2008, 09:45 Delegate Stefania said...

Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course

Introduction Excel

I would like to khow how to link two worksheets

Thu 27 Nov 2008, 11:56 Trainer Amanda said...

RE: Introduction Excel

Hello Stefania

Thank you for your question.

You can create a link between two worksheets by creating a simple formula.

1. Select the cell you wish to create the link in.
2. Type in =
3. Click on the sheet containing the cell you want to link to.
4. Press Enter.

Kind regards
Amanda

Training courses

98.3 % recommend us

More live stats...

Training information:

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips