multiple work sheets

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple work sheets

Multiple work sheets

resolvedResolved · Urgent Priority · Version 2003

Dianah has attended:
Excel Intermediate course

Multiple work sheets

how would i link my information form worksheet to worksheet and formulate it to work together in calucation

RE: multiple work sheets

Hi Dianah

Thank you for your question; and welcome to the forum.

To link one cell to another cell in a different worksheet is straightforward:

1. Select the cell you wish to create the link in.
2. Type in =
3. Select the cell that contains the data you wish to link to.
4. Press Enter.

This creates the link from one cell to another.

If you wish to add data from different cells together, select the cell containing the link and click in the formula bar at the top of the screen, type in + then select the cell that contains the data you want to add to the first cell you selected. Continue typing in + and selecting cells one at a time to include more cells in the calculation.

Always press Enter when you have finished.

If you are multiplying use * instead of +
If you are subtracting use - instead of +
If you are dividing use / instead of +

I hope this helps.
Amanda


 

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips


Server loaded in 0.08 secs.