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

introduction excel

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

Introduction Excel

ResolvedVersion 2003

Introduction Excel

I would like to khow how to link two worksheets

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.