excel software training london - linking 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 » excel software training london - Linking work sheets

excel software training london - Linking work sheets

resolvedResolved · Low Priority · Version Standard

Anika has attended:
Excel Intermediate course

Linking work sheets


How do i link work sheets together. To Get one sum.

RE: Linking work sheets

To add cells on the same sheet you would use the formula:

=A1+B1


To add cells on different sheets you would use the formula:

=A1+Sheet2!B1

Where "Sheet2" is the name of the worksheet
Separated with a !


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.16 secs.