98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version Standard
Mon 29 Jan 2007, 16:40Delegate Louise said...
Mon 29 Jan 2007, 16:44Trainer Richard said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up time greater than 24 hoursWhen 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. |
