Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Powerpoint

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Powerpoint

Resolved · Low Priority · Version 2007

Reply Tue 5 Jul 2011, 16:20Delegate simone said...

simone has attended:
Powerpoint Intermediate Advanced course

Powerpoint

From an Excel document how do you link just one sheet to powerpoint presentation

For upcoming training course dates see: Pricing & availability

Reply Thu 7 Jul 2011, 09:10Trainer Simon said...

RE: Powerpoint

Hi Simone,

Thank you for your question.

Highlight the text you want to create the hyperlink on and go to the Insert Tab and then Hyperlink.

Navigate to the spreadsheet and select it. In the Address line at the bottom of the Hyperlink box, add a hash at the end of the file address followed by the sheet name and cell reference:

e.g. Z:\Book1.xlsx#Sheet2!B2

I hope this answers your question. Let me know if it does.

Regards

Simon

Wed 13 Jul 2011: Automatically marked as resolved.

Powerpoint articles

· The Power Of Video In PowerPoint
· How To Make Sure Your Audience Is Just Loving It
· Focussing In On Picture Cropping With PowerPoint
· Creating A Photo Album In PowerPoint 2003
· How To Successfully Broadcast A Live Presentation

Please browse our web site to find out more about
powerpoint+training and other Microsoft training courses.

Powerpoint tip:

Embedding fonts in a presentation

If you create a PowerPoint presentation which is likely to be viewed on other computers, there can be problems with displaying the font/s you have used in your presentation when it is opened on other machines.

You can embed the fonts you use in your presentation in order to try and get around this issue.

When you go to save your presentation (File - Save as), go to the Tools button at the top of the Save As dialogue box and select Save Options. Under 'Font options for current document only', tick the Embed TrueType fonts option, then select the secondary option underneath that applies best to your situation.

Click OK, then Save.

View all Powerpoint hints and tips