1 / 12

EXCEL WORKSPACES and HYPERLINKS

EXCEL WORKSPACES and HYPERLINKS. June 21, 2012. Creating an Excel Workspace. A WorkSpace (. xlw ) is an Excel file that saves information about all of the currently open workbooks, such as: screen locations , window sizes, zoom magnifications, and other settings.

makara
Télécharger la présentation

EXCEL WORKSPACES and HYPERLINKS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EXCELWORKSPACESand HYPERLINKS June 21, 2012

  2. Creating an Excel Workspace • A WorkSpace (.xlw) is an Excel file that saves information about all of the currently open workbooks, such as: • screen locations, window sizes, zoom magnifications, and other settings. • Helpful when consistently working with the same group of Excel workbooks and want to save time opening each workbook and arranging them on the screen.

  3. Creating an Excel WorkSpace • Open all the files you want to define (associate) and arrange them as you want them to be grouped for the Workspace. • Go to the [View] tab – Windows group • Click the Save Workspace button This DOES NOT save changes to the individual files. You must save each workbook individually to keep any changes. This creates a “File” that defines what to open and how to view it.

  4. The file Extension for a WORKSPACE file is . XLW It will create a new FILE icon for the WORKSPACE

  5. File Dialog Box

  6. DEFINING HYPERLINKS

  7. Creating a Hyperlink • A hyperlink is a link in a file to information: • Within a file • To another file • To a website • Any OBJECT can be used as a “button” for the Hyperlink • Select the text, graphic, or cell you want to use as the hyperlink button • Go to the [Insert] tab – Links group • Click the Hyperlinkbutton

  8. Creating a Hyperlink

  9. Creating a Hyperlink • To link to an existing file or Web Page • Click Existing File or Web Page in the Link to list • Select the file or Web page from the Look in box • To link to a location in the current workbook: • Click Place in This Document in the Link to list • Select the location (cell or range) in the current workbook • To link to a New Document • Click Create New Document in the Link to list • Specify the filename and path of the new document • To link to an e-mail address • Click E-mail Address in the Link to list • Enter the e-mail address of the recipient and a subject line for the e-mail message

  10. Exercise: #1 This example will group the: New Mexico Utah and TravelTotal_2010 workbooks together as a WORKSPACE You will also INSERT a hyperlink to a WORD Document

  11. Exercise: #2 Use Icons to make Hyperlinks To open various files.

  12. End of SectionWORKSPACESand HYPERLINKS

More Related