MS-Excel / General Formatting

---

Insert a Hyperlink in Workbook

1. Select a cell or graphic object then choose Insert> Links> Hyperlink. The Insert Hyperlink dialog box appears.
   If you clicked a blank cell, in the Text to Display box, you can type the text you want the cell to display. If you started with a cell already containing data or an object, you can change the displayed text.
2. Select an option:
   
   
   • If you want to link to a different file, locate and select the filename. When the user clicks the link, the referenced file will open.
   • If you want to link to a Web site, enter the Web address in the Address text box. When the user clicks the link, the Web browser opens to the referenced Web page.
   • If you want to link to a different cell in the current workbook, click the Place in This Document button, then specify which worksheet and cell location you want to reference. When the user clicks on this link, he or she is redirected to the specified cell address.
   • If you want to send an e-mail when the link is selected, click the E-mail Address button and then enter the recipient's e-mail address and a subject. When the user clicks the link, the user's e-mail program starts.
     
     
3. In the end click OK.

Click the ScreenTip button to enter text you want displayed, such as a prompt or hint that appears whenever the user pauses the mouse over the link. To remove a Hyperlink, right-click the link and select Remove Hyperlink.

Arranging Windows Automatically

If you want all your open workbook windows visible on-screen, you can move and resize them manually or you can have Excel do it automatically. Follow these steps to make all open workbooks visible on the Excel screen:

1. Click the View tab in the Ribbon.
2. Click the Arrange All button. Excel displays the Arrange Windows dialog box.
3. Choose from the Tiled, Horizontal, Vertical, or Cascade options.
4. Click OK.

You can save the layout of your open workbooks for future use.

Changing the Default File Location

When you are opening a document in Excel, by default the Open dialog box points to the My Documents folder (Windows XP) or the Documents folder (Windows Vista) as the starting location to open documents. If you keep frequently used documents in a different folder, you may want the Open dialog box to point to this different folder to save some navigation steps. To change the default folder, follow these steps:

1. Click the Office button, and then click the Excel Options button. The Excel Options dialog box appears. The options are divided into sections, which appear in a list on the left side of the dialog box.
2. Click the Save section.
3. In the Default File Location text box, enter the path of the new default starting location to open documents. For example, if your new default document location is in a subfolder named Excel, which itself is in the My Documents or Documents folder, add \Excel to the default path. The new location in the text box should read C:\Users\Username\Documents\ Excel, where Username is the actual name of the user indicated in the text box.
4. Click OK.

Closing a Workbook

If multiple workbooks are open, ensure that the workbook you want to close is active as follows: Click the View tab on the Ribbon, click the Switch Windows button, and select the workbook from the list of names in the menu. Use any of the following methods to close the workbook:

1. Click the Office button and then choose Close.
2. Click the Close button on the far right of the Ribbon tab area (or on the workbook's title bar if the workbook is not maximized).
3. Double-click the Control button on the far left of the workbook's title bar if the workbook is not maximized.
4. Press Ctrl+F4. Press Ctrl+W.

If you have made any changes to your workbook since the last time you saved it, Excel asks whether you want to save the changes before closing the workbook.