excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Excel

resolvedResolved · Medium Priority · Version 2003

replyReply Wed 28 May 2008, 16:00Delegate Ashley said...

Ashley has attended:
Excel Advanced course

Excel

can i use a hyperlink to focus on a particular area of an excel spreadsheet?

For upcoming training course dates see: Pricing & availability

replyReply Fri 30 May 2008, 15:55Trainer Amanda said...

RE: excel

Hi Ashley

Thank you for your question.

Can you please clarify for me if you wish to create the hyperlink in PowerPoint; or in Excel?

Thank you
Amanda

replyReply Mon 2 Jun 2008, 08:37Delegate Ashley said...

RE: excel

Hi Amanda,

I would be creating the hyperlink in Powerpoint for presentation purposes. When i create the hyperlink though, i only want to see a particular part of the spreadsheet though?

Thanks for all your assistance,

Ashley

replyReply Wed 4 Jun 2008, 12:04Trainer Amanda said...

RE: excel

Hi Ashley

I've tried playing around with this but I can't find a way of zooming in on a particular part of a spreadsheet.

All I can suggest is either hiding the parts of the sheet in Excel you don't want to be visible when the hyperlink is clicked; or copying and pasting the bits you'd like to show when the link is clicked onto a separate sheet.

Amanda

 

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

Powerpoint tip:

Controlling alignment and spacing between shapes in PowerPoint

Instead of trying to align shapes exactly or space shapes an even distance apart from each other by dragging them manually on the screen, use features from the Drawing toolbar to align or space shapes perfectly.

Both the Align and the Distribute features can be found by clicking the 'Draw' button on the Drawing toolbar.

The Align feature allows you to align shapes along the top, bottom, left, right or middle edges or positions.

The Distribute feature will automatically adjust the position of shapes to create an even amount of space between them, either vertically or horizontally.

Before using either of these features, you need to select the shapes you wish to align or distribute on your slide. This can be done by clicking on one shape, holding down the Shift key and continuing to hold Shift down while you click the other shapes you want to select.

View all Powerpoint hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard