Ashley has attended:
Excel Advanced course
Excel
can i use a hyperlink to focus on a particular area of an excel spreadsheet?
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
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
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