microsoft excel courses in london - linking pages

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Linking pages

microsoft excel courses in london - Linking pages

resolvedResolved · Low Priority · Version Standard

Louise has attended:
Excel Intermediate course

Linking pages

how do i link speadsheet pages?

RE: linking pages

You can do this by entering a basic formula.

Normall you would use something like

=A1+B1

where to link more than one sheet you would create something like:

=A1+Sheet2!B1

Create the formula like you normally do, and select the relevant sheet with your mouse. Excel will enter the correct format for you.


 

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips


Server loaded in 0.21 secs.