Save all or part of a workbook to a static Web page

You can save an entire workbook, including tabs for navigating worksheets, or portions of a workbook, such as a range or chart, to a static Web page so that users can view your Microsoft Office Excel data on the World Wide Web. For example, if you have sales figures on an Excel worksheet, you can save the figures along with a chart to compare those figures, and users can view the information without having to open Office Excel.

 Note    You can also publish a workbook to Excel Services which makes it simple to use, share, secure, and manage Microsoft Office Excel 2007 workbooks (.xslx, .xslb) as interactive reports. For more information, see Publish a workbook to Excel Services.

What do you want to do?

Learn more about saving Excel data to a static Web page

Save Excel data to a static Web page

Enable AutoRepublish or make AutoRepublish unavailable

AutoRepublish errors and warnings

Issues with saving to a Web page

Learn more about saving Excel data to a static Web page

When you save Excel data to a static Web page, it is important to understand the AutoRepublish feature, where supporting files are located, how to define hyperlinks, and the differences between reopening a saved Web page instead of reopening the original workbook.

Using the AutoRepublish feature

Each time that you save your workbook, you can automatically republish it to the Web by selecting the AutoRepublish every time this workbook is saved box in the Publish as Web Page dialog box. (On the Microsoft Office Button , click Save As, select a Web page format (1033.aspx, 1033.aspxl, .mht, .mhtml), and then click Publish.)

However, there may be times when you don't want to automatically republish items in your workbook, for example, when you:

• Have entered confidential or sensitive information that should not be saved to a public location
• Are temporarily disconnected from a network or Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.) location
• Are saving a workbook that was created by someone who is not a trusted source (The workbook could contain macros that collect information from a network location by using your credentials, and then save that information to a public location.)

If necessary, you can make AutoRepublish temporarily unavailable (for the current open and close session) or permanently unavailable (every time that you open, save, and close).

About supporting Web files and hyperlinks

Web pages often contain images and other supporting files as well as hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) to other Web pages. When supporting files or pages are moved, the Web page that refers to them may no longer work properly.

Supporting files

When you save an Excel workbook or worksheet as a Web page (1033.aspx, 1033.aspxl), Excel creates a supporting folder named "filename_ files" where it saves all of the page's supporting files — such as bullets, background textures, and graphics. For example, if your file is named Page11033.aspx, Excel creates a subfolder named "Page1_ files." Excel also assigns names, such as image001.jpg and image002.gif, to the supporting files.

If you move or copy your Web page to another location, you must also move the supporting folder so that you maintain all links to your Web page. When you resave to another location, Excel automatically copies the supporting folder for you.

For example, suppose you have a Web page: http://example.microsoft.com/Page11033.aspx. It includes bullets, which are stored in a supporting folder: http://example.microsoft.com/Page1_ files. The relative paths for the bullet files are /Page1_ files/image001.gif and /Page1_ files/image002.gif. If you move Page11033.aspx to a new location, such as http://example.microsoft.com/, you must also move the supporting files folder (Page1_ files) to http://example.microsoft.com/.

Relative and absolute hyperlinks

When you create Web pages, Excel automatically manages the related files and hyperlinks so that the images appear and the links work when the pages are placed on the final Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.).

When all the files — such as bullets, navigational buttons, background textures, graphics, and Web pages that you create hyperlinks to — are placed on, or saved to, the same Web server, Excel maintains the links as relative links (relative link: When a hyperlink uses a path based on a relative link, you can move the file that contains the hyperlink and the hyperlink destination without breaking the hyperlink. Move the file that contains the hyperlink and its destination together.).

Hyperlinks to Web sites on other servers — for example, a list of your favorite places on the Web — are maintained as absolute links — that is, fixed file locations (fixed file location: The full or absolute address of a file. For example, www.microsoft.com/location/sublocation/filename1033.aspx. By contrast, a relative file location is an address that's relative to the active document or a hyperlink base.).

When you save your Web pages to a different location, links that can't be converted to relative links remain as absolute links.

When you delete elements that were saved as relative links (relative link: When a hyperlink uses a path based on a relative link, you can move the file that contains the hyperlink and the hyperlink destination without breaking the hyperlink. Move the file that contains the hyperlink and its destination together.), Excel automatically deletes the corresponding supporting files from the supporting folder.

Language-specific names for Web page supporting files

A suffix appears in the language of the version of Microsoft Office System that was used to save the file as a Web page. For example, suppose that you use the Dutch language version of Microsoft Office System to save a file named Page1 as a Web page. The default name of the supporting folder would be Page1_bestanden. The following section contains a complete list of languages and default folder names.

Languages and default folder names

7. To add a title that is centered over the selection and in the title bar of the browser, click Change under Publish as. Type the title that you want, and then click OK.
8. Next to the File name box, click Browse, and locate the drive, folder, Web folder (Web folder: A shortcut you use to save, open, copy, or delete files on a Web or FTP server. Some Web folders, such as document libraries, have functionality not available with local folders. You'll find Web folders in My Network Places or Web Folders.), Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), HTTP (HTTP: Internet protocol that delivers information on the World Wide Web. Makes it possible for a user with a client program to enter a URL (or click a hyperlink) and retrieve text, graphics, sound, and other digital information from a Web server.) site, or FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) location where you want to save your Web page, and then click OK.

You can also choose an existing Web page to append to or replace as long as you have permission to modify the Web page and have access to the file.

Tip  When you first create your Web page, it is a good idea to save the Web page on your local hard drive so that you can make any changes or corrections that you need to before you publish the Web page on a public or shared location.

9. To view the Web page in your browser after you save it, select the Open published Web page in browser check box.

 Note    To preview the page without saving it you can use the Web Page Preview command, which you can add to the Quick Access Toolbar.

10. If you expect to make changes in the workbook later and want to automatically republish the items each time that the workbook is saved, select the AutoRepublish every time this workbook is saved check box.
11. To change additional related options, do one or more of the following:
    • To change Web page options, click the arrow next to Tools, and then click Web Options. For more information, see Web Page options.
    • To change picture compression options, click the arrow next to Tools, and then click Compress Pictures. For more information, see Reduce the file size of a picture.
12. Click Publish.
13. If you are saving to an existing Web page, a message appears. Do one of the following:
    • To copy over the existing page, click Replace file.
    • To append your data to the end of the Web page, click Add to file.

 Top of Page

Enable AutoRepublish or make AutoRepublish unavailable

If you have enabled the AutoRepublish feature, a message appears each time that you save the workbook. You can make AutoRepublish temporarily or permanently unavailable, or you can keep it. You can also control how the message is displayed.

 Note    You can tell that a workbook is set to AutoRepublish when you see Publishing to Page: filename in the status bar (status bar: A horizontal bar at the bottom of the screen that displays information about the current condition of the program, such as the status of items in the window, the progress of the current task, or information about the selected item.) when you save the workbook.

Make AutoRepublish temporarily unavailable

When the message appears, do the following:

1. Select the Disable the AutoRepublish feature while this workbook is open option.
2. Click OK.

AutoRepublish is not available for the current session of the workbook only, or until you close the workbook. The next time that you open the workbook, AutoRepublish will be enabled.

Disable AutoRepublish permanently

1. Open the workbook that is set to automatically republish.
2. On the Microsoft Office Button , click Save As, select a Web page format (1033.aspx, 1033.aspxl, .mht, .mhtml), and then click Publish.
3. In the Choose list, click Previously published items.
4. Select the item that you want to discontinue republishing automatically, and click Remove. Repeat for each item that you don't want to automatically republish.
5. Click Close.
6. To save the change to your workbook, on the Microsoft Office Button , click Save.

Continue with AutoRepublish

When the message appears, do the following:

• Click Enable the AutoRepublish feature in the message that is displayed each time that you save the workbook.

Control display of the AutoRepublish message

If you don't want the message to appear every time that you save the workbook, you can select the Do not show this message again check box. Be aware, however, that this setting then applies to all Excel workbooks that are set to AutoRepublish.

 Top of Page

AutoRepublish errors and warnings

You may receive the following error or warning messages when you use the AutoRepublish feature.

WARNING: External references converted to values in <file name/path>

The workbook you are republishing contains references to other workbooks, pages, or documents, such as a link from Book1.xls that gets the value in cell A1 of Book2.xls. Because external references are not supported in the resulting published Web page, the reference is converted to the last retrieved value on the Web page. The reference in the workbook, however, remains intact.

WARNING: Hidden formulas no longer protected in <file name/path>

Hidden formulas become visible on published Web pages. If you don't want hidden formulas to be shown on the Web page, remove them before saving and republishing.

WARNING: Precision as displayed option not supported in <file name/path>

This workbook uses the Precision as displayed option, which is available under the Calculation options section on the Formulas category in the Excel Options dialog box (On the Microsoft Office Button , click Excel Options). This means that stored values in cells are no longer precise to 15 digits, but are precise to the displayed value in the cell. Because Precision as displayed is not supported on Web pages, results of formulas or values you enter or change on the Web page published from this workbook will no longer have the Precision as displayed option applied to them.

WARNING: 1904 date system converted to 1900 date system in <file name/path>

This workbook uses the 1904 date system, an option available under the When calculating this workbook section on the Advanced category in the Excel Options dialog box (On the Microsoft Office Button , click Excel Options). Generally used for Macintosh compatibility, this option changes the starting date from which all dates are calculated in Microsoft Excel from January 1, 1900, to January 2, 1904. Because Web pages do not support the 1904 date system, your dates will be converted to the 1900 date system on the Web page, and may show a difference of approximately four years.

ERROR: Cannot access <file name/path>

The items you are republishing cannot be saved to the location where they were previously published.

• Check if the Web site or server to which you are publishing is functioning properly.
• Check if the location to which you previously published has changed names or moved.
• Make sure you have proper permissions to the location to which your items were previously published.

ERROR: There is protected data in <file name/path>

Protected data cannot be saved in a Web page. To republish the workbook, you must first unprotect the data and remove all passwords. If necessary, you should move confidential or sensitive information into a workbook that you are not publishing.

ERROR: This file is not in the proper format <file name/path>

You cannot use the AutoRepublish feature to publish Microsoft Excel data to a file that is not in a Web page format (1033.aspx, 1033.aspxl, .mht, mhtml). Make sure you are publishing to a page that is in an HTML format.

ERROR: Previously published data has been deleted from <file name/path>

Items in the workbook set to AutoRepublish no longer exist.

ERROR: There is not enough memory to publish <file name/path>

• Close any unnecessary programs or windows on your desktop to recapture available memory on your system.
• Check the amount of disk space available at the location to which you are trying to publish and make sure there is enough available for your Web page.
• Check to make sure that you have not exceeded the limits of your assigned space at the location to which you are publishing.
• Try reducing the file size of the workbook by removing sheets, objects, or any unnecessary items.
• Check the amount of disk space on your computer. Delete unnecessary files from your hard disk.
• Check the random access memory (RAM) on your system and make sure it is working properly and that you have the recommended amount for your version of Microsoft Office or Office Excel.

 Top of Page

Issues with saving to a Web page

When you save a workbook to a Web page, you may encounter the following issues:

Issue: I don't see conditional formats

Conditional formatting is not supported with Single File Web Page (.mht, .mhtml) pages; use the Web Page (1033.aspx, 1033.aspxl) file format instead. Data bars, color scales, and icon sets are not supported in either format.

Issue: Text in a cell is cut off when I save data as a Web page

If you notice that text in a cell is truncated or not completely displayed, try the following:

Modify cells that contain automatically wrapped text   You might have formatted cells with wrapped text before you saved the data as a Web page. To prevent text from being cut off when you save it, you can shorten the text, use multiple cells for text, or widen the column in your worksheet, and then save the data.

Widen the column the text is in   Where text in a cell overlaps another cell, the overlapping portion may not be saved. Widen the column the text is in so that it does not overlap other cells.

Realign the text   If you see text that is cut off in a cell, the text was longer than the length of the cell when it was saved, and it was right-aligned or center-aligned. Edit the original workbook and realign the text as left (indent).

Issue: Rotated text doesn't appear correctly when I save data as a Web page

You can't use rotated or vertical text when you save Excel data as a Web page. Rotated and vertical text are converted to horizontal text.

Issue: Items I save to an existing Web page always appear at the bottom of the page

When you save Excel data to an existing Web page, Excel always appends the data to the bottom of the page.

To move the Excel data to another position on the Web page, you can open the Web page in a design program, such as Microsoft Office SharePoint Designer, and rearrange the items.

Issue: I moved my Web page to another location, and now some of the links are broken

When you save a Web page, Excel by default saves all supporting files — such as bullets, background textures, and graphics — in a supporting subfolder. If you move or copy your Web page to another location, you must also move the supporting folder so that you maintain all of the links to your supporting files.

Issue: I see a red X on my Web page

A red X indicates a missing graphic. If you move or copy your Web page to a new location without moving the supporting files, the links to graphics — such as photos, bullets, and background textures — may be broken.

 Top of Page

Excel > Excel and the Web > Basics

Create a Web query parameter query

You can edit a Web query so that it prompts you for variable parameters. For example, a Web query that gets stock quotes from a Web page can prompt you for a parameter, such as a stock symbol, each time you update the data. You can create a Web query parameter query only from a saved Web query file (.iqy).

1. In Windows Explorer, navigate to the query file on your computer.
2. Right-click the file, and then click Edit with Notepad. The query opens in Microsoft Notepad, where you can make changes to the file.
3. In the text of the file, find the URL of the Web address from which the imported data originated. For example:

http://moneycentral.msn.com/investor/external/excel/quotes.asp

At the end of the URL, type the following (do not insert a space at the end of the URL):

?SYMBOL=["Parameter", "Prompt"]

For example, type:

?SYMBOL=["QUOTE", "Enter one or more financial symbols separated by commas."]

4. On the File menu, click Save, and then exit Notepad.

See Also

• Customize a parameter query
• Get external data from a Web page

Excel > Excel and the Web > Hyperlinks

Create or remove a hyperlink

Excel 2007

For quick access to related information in another file or on a Web page, you can insert a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) in a worksheet cell. You can also insert hyperlinks in specific chart elements.

What do you want to do?

Learn more about hyperlinks

Create a hyperlink to a new file

Create a hyperlink to an existing file or Web page

Create a hyperlink to a specific location in a workbook

Create a custom hyperlink by using the HYPERLINK function

Create a hyperlink to an e-mail address

Create an external reference link to worksheet data on the Web

Set the base address for the hyperlinks in a workbook

Delete a hyperlink

Learn more about hyperlinks

A hyperlink is a link from a document that opens another page or file when you click it. The destination is frequently another Web page, but it can also be a picture, or an e-mail address, or a program. The hyperlink itself can be text or a picture.

When a site user clicks the hyperlink, the destination is shown in a Web browser (Web browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.), opened, or run, depending on the type of destination. For example, a hyperlink to a page shows the page in the Web browser, and a hyperlink to an AVI (AVI: A Microsoft Windows multimedia file format for sound and videos that uses the Microsoft Resource Interchange File Format (RIFF) specification.) file opens the file in a media player.

How hyperlinks are used

You can use hyperlinks to do the following:

• Navigate to a file or Web page on a network, intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or Internet
• Navigate to a file or Web page that you plan to create in the future
• Send an e-mail message
• Start a file transfer, such as downloading or an FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) process

When you point to text or a picture that contains a hyperlink, the pointer becomes a hand , indicating that the text or picture is something that you can click.

What a URL is and how it works

When you create a hyperlink, its destination is encoded as a Uniform Resource Locator (URL) (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.), such as:

http://example.microsoft.com/news1033.aspx

file://ComputerName/SharedFolder/FileName1033.aspx

A URL contains a protocol (protocol: A method of accessing a document or service over the Internet, such as File Transfer Protocol (FTP) or Hypertext Transfer Protocol (HTTP).), such as HTTP (HTTP: Internet protocol that delivers information on the World Wide Web. Makes it possible for a user with a client program to enter a URL (or click a hyperlink) and retrieve text, graphics, sound, and other digital information from a Web server.), FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.), or FILE, a Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.) or network location, and a path and file name. The following illustration defines the parts of the URL:

Protocol used (http, ftp, file)

Web server or network location

Path

File name

Absolute and relative hyperlinks

An absolute URL contains a full address, including the protocol (protocol: A method of accessing a document or service over the Internet, such as File Transfer Protocol (FTP) or Hypertext Transfer Protocol (HTTP).), the Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), and the path and file name.

A relative URL has one or more missing parts. The missing information is taken from the page that contains the URL. For example, if the protocol and Web server are missing, the Web browser uses the protocol and domain, such as .com, .org, or .edu, of the current page.

It is common for pages on the Web to use relative URLs that contain only a partial path and file name. If the files are moved to another server, any hyperlinks will continue to work as long as the relative positions of the pages remain unchanged. For example, a hyperlink on Products1033.aspx points to a page named apple1033.aspx in a folder named Food; if both pages are moved to a folder named Food on a different server, the URL in the hyperlink will still be correct.

In a Microsoft Office Excel workbook, unspecified paths to hyperlink destination files are by default relative to the location of the active workbook. You can set a different base address to use by default so that each time that you create a hyperlink to a file in that location, you only have to specify the file name, not the path, in the Insert Hyperlink dialog box.

 Top of Page

Create a hyperlink to a new file

1. On a worksheet, click the cell where you want to create a hyperlink.

Tip  You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

Tip   You can also right-click the cell or graphic and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click Create New Document.
4. In the Name of new document box, type a name for the new file.

Tip  To specify a location other than the one shown under Full path, you can type the new location preceding the name in the Name of new document box, or you can click Change to select the location that you want and then click OK.

5. Under When to edit, click Edit the new document later or Edit the new document now to specify when you want to open the new file for editing.
6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

 Top of Page

Create a hyperlink to an existing file or Web page

1. On a worksheet, click the cell where you want to create a hyperlink.

Tip  You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

Tip   You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click Existing File or Web Page.
4. Do one of the following:
   • To select a file, click Current Folder, and then click the file that you want to link to.

Tip  You can change the current folder by selecting a different folder in the Look in list.

• To select a Web page, click Browsed Pages and then click the Web page that you want to link to.
• To select a file that you recently used, click Recent Files, and then click the file that you want to link to.
• To enter the name and location of a known file or Web page that you want to link to, type that information in the Address box.
• To locate a Web page, click Browse the Web , open the Web page that you want to link to, and then switch back to Office Excel without closing your browser.
5. If you want to create a hyperlink to a specific location in the file or on the Web page, click Bookmark, and then double-click the bookmark (bookmark: A location or selection of text in a file that you name for reference purposes. Bookmarks identify a location within your file that you can later refer or link to.) that you want.

 Note    The file or Web page that you are linking to must have a bookmark.

6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

 Top of Page

Create a hyperlink to a specific location in a workbook

To link to a location in the current workbook or another workbook, you can either define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the destination (destination: General term for the name of the element you go to from a hyperlink.) cells or use a cell reference.

1. To use a name, you must name the destination cells in the destination workbook.

How to name a cell or a range of cells

1. Select the cell, range of cells, or nonadjacent selections (nonadjacent selection: A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, make sure that the combined selections form a rectangular shape.) that you want to name.
2. Click the Name box at the left end of the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) .

Name box

3. In the Name box, type the name for the cells, and then press ENTER.

 Note    Names cannot contain spaces and must begin with a letter.

2. On a worksheet of the source (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) workbook, click the cell where you want to create a hyperlink.

Tip  You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.

3. On the Insert tab, in the Links group, click Hyperlink.

Tip   You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

4. Under Link to, do one of the following:
   1. To link to a location in your current workbook, click Place in This Document.
   2. To link to a location in another workbook, click Existing File or Web Page, locate and select the workbook that you want to link to, and then click Bookmark.
5. Do one of the following:
   1. In the Or select a place in this document box, under Cell Reference, click the worksheet that you want to link to, type the cell reference in the Type in the cell reference box, and then click OK.
   2. In the list under Defined Names, click the name that represents the cells that you want to link to, and then click OK.
6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

 Top of Page

Create a custom hyperlink by using the HYPERLINK function

You can use the HYPERLINK function to create a hyperlink that opens a document that is stored on a network server, an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or the Internet. When you click the cell that contains the HYPERLINK function, Excel opens the file that is stored at the location of the link.

 Top of Page

Create a hyperlink to an e-mail address

When you click a hyperlink to an e-mail address, your e-mail program automatically starts and creates an e-mail message with the correct address in the To box, provided that you have an e-mail program installed.

1. On a worksheet, click the cell where you want to create a hyperlink.

Tip  You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

Tip   You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click E-mail Address.
4. In the E-mail address box, type the e-mail address that you want.
5. In the Subject box, type the subject of the e-mail message.

 Note    Some Web browsers (Web browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.) and e-mail programs may not recognize the subject line.

6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

Tip  You can also create a hyperlink to an e-mail address in a cell by typing the address directly in the cell. For example, a hyperlink is created automatically when you type an e-mail address, such as someone@example.com.

 Top of Page

Create an external reference link to worksheet data on the Web

You can insert one or more external reference (also called links) from a workbook to another workbook that is located on your intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.) or on the Internet. The workbook must not be saved as an HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file.

1. Open the source workbook and select the cell or cell range that you want to copy.
2. On the Home tab, in the Clipboard group, click Copy.

3. Switch to the worksheet that you want to place the information in, and then click the cell where you want the information to appear.
4. On the Home tab, in the Clipboard group, click Paste Special.
5. Click Paste Link.

Excel creates an external reference link for the cell or each cell in the cell range.

 Note    You may find it more convenient to create an external reference link without opening the workbook on the Web. For each cell in the destination workbook where you want the external reference link, click the cell, and then type an equal sign (=), the URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) address, and the location in the workbook. For example:

='http://www.someones.homepage/[file.xls]Sheet1'!A1

='ftp.server.somewhere/file.xls'!MyNamedCell

 Top of Page

Set the base address for the hyperlinks in a workbook

By default, unspecified paths to hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time that you create a hyperlink to a file in that location, you only have to specify the file name, not the path, in the Insert Hyperlink dialog box.

1. Click the Microsoft Office Button , click Prepare, and then click Properties.
2. In the Document Information Panel, click Document Properties, and then click Advanced Properties.
3. Click the Summary tab.
4. In the Hyperlink base box, type the path that you want to use.

 Note    You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box.

 Top of Page

Delete a hyperlink

To delete a hyperlink, do one of the following:

• To delete a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and then click Clear Contents on the shortcut menu.
• To delete a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.
• To turn off a single hyperlink, right-click the hyperlink, and then click Remove Hyperlink on the shortcut menu.
• To turn off several hyperlinks at once, do the following:
  1. In a blank cell, type the number 1.
  2. Right-click the cell, and then click Copy on the shortcut menu.
  3. Hold down CTRL and select each hyperlink that you want to turn off.

Tip  To select a cell that has a hyperlink in it without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button.

4. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special.

5. Under Operation, click Multiply, and then click OK.
6. On the Home tab, in the Styles group, click Cell Styles.

7. Under Good, Bad, and Neutral, select Normal.

 Top of Page

See Also

• Change a hyperlink
• Copy or move a hyperlink
• Select a hyperlink without activating the link

Excel > Excel and the Web > Hyperlinks

Copy or move a hyperlink

Excel 2007

1. Right-click the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) that you want to copy or move, and then click Copy or Cut on the shortcut menu.
2. Right-click the cell that you want to copy or move the hyperlink to, and then click Paste on the shortcut menu.

See Also

• Change a hyperlink
• Create or remove a hyperlink
• Select a hyperlink without activating the link

Excel > Excel and the Web > Hyperlinks

Change a hyperlink

Excel 2007

You can change an existing hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) in your workbook by changing its destination (destination: General term for the name of the element you go to from a hyperlink.), its appearance, or the text or graphic that is used to represent it.

What do you want to do?

Change the destination of a hyperlink

Change the appearance of hyperlink text

Change the text or graphic for a hyperlink

Change the destination of a hyperlink

1. Select the cell or graphic that contains the hyperlink that you want to change.

Tip  To select a cell that contains a hyperlink without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button. You can also use the arrow keys to select the cell. To select a graphic, hold down CTRL and click the graphic.

2. On the Insert tab, in the Links group, click Hyperlink.

Tip   You can also right-click the cell or graphic and then click Edit Hyperlink on the shortcut menu, or you can press CTRL+K.

3. In the Edit Hyperlink dialog box, make the changes that you want.

 Note    If the hyperlink was created by using the HYPERLINK worksheet function, you must edit the formula to change the destination. Select the cell that contains the hyperlink, and then click the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) to edit the formula.

 Top of Page

Change the appearance of hyperlink text

You can change the appearance of all hyperlink text in the current workbook by changing the cell style for hyperlinks.

1. On the Home tab, in the Styles group, click Cell Styles.

2. Under Data and Model, do the following:
   • To change the appearance of hyperlinks that have not been clicked to go to their destinations, right-click Hyperlink, and then click Modify.
   • To change the appearance of hyperlinks that have been clicked to go to their destinations, right-click Followed Hyperlink, and then click Modify.

 Note    The Hyperlink cell style is available only when the workbook contains a hyperlink. The Followed Hyperlink cell style is available only when the workbook contains a hyperlink that has been clicked.

3. In the Style dialog box, click Format.
4. On the Font tab and Fill tab, select the formatting options that you want, and then click OK.

 Notes 

• The options that you select in the Format Cells dialog box appear as selected under Style includes in the Style dialog box. You can clear the check boxes for any options that you don't want to apply.
• Changes that you make to the Hyperlink and Followed Hyperlink cell styles apply to all hyperlinks in the current workbook. You cannot change the appearance of individual hyperlinks.

 Top of Page

Change the text or graphic for a hyperlink

1. Select the cell or graphic that contains the hyperlink that you want to change.

Tip  To select a cell that contains a hyperlink without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button. You can also use the arrow keys to select the cell. To select a graphic, hold down CTRL and click the graphic.

2. Do one or more of the following:
   • To change the hyperlink text, click in the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), and then edit the text.
   • To change the format of a graphic, right-click it, and then click the option that you need to change its format.
   • To change text in a graphic, double-click the selected graphic, and then make the changes that you want.
   • To change the graphic that represents the hyperlink, insert a new graphic, make it a hyperlink with the same destination, and then delete the old graphic and hyperlink.

 Top of Page

See Also

• Copy or move a hyperlink
• Create or remove a hyperlink
• Select a hyperlink without activating the link

Excel > Excel and the Web > Hyperlinks

Select a hyperlink without activating the link

Excel 2007

To select a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) without activating the link to its destination (destination: General term for the name of the element you go to from a hyperlink.), do one of the following:

• Click the cell that contains the hyperlink, hold the mouse button until the pointer becomes a cross , and then release the mouse button.
• Use the arrow keys to select the cell that contains the hyperlink.
• If the hyperlink is represented by a graphic, hold down CTRL, and then click the graphic.

See Also

• Change a hyperlink
• Copy or move a hyperlink
• Create or remove a hyperlink

Excel > Excel and the Web > Working with smart tags

Create, use, and remove smart tags

Excel 2007

You can save time by using smart tags to perform actions (actions: Tasks that can be performed by using smart tags. For example, adding a name to a Microsoft Outlook Contacts folder is one action that might be taken with a person name smart tag.) in Microsoft Office Excel that you would usually open other programs to perform. Smart tags recognize and label particular data types (such as names or stock ticker symbols) with a Smart Tag Actions button to make it easy for you to complete some of the most common tasks for that data type. You can click the Smart Tag Actions button to choose an appropriate action.

What do you want to do?

Learn more about smart tags

Use a smart tag

Change smart tag options

Check for new smart tags

Remove smart tags

Learn more about smart tags

The purple triangles in the corners of cells on a worksheet indicate the presence of a smart tag, which can convey information or help you to quickly complete a useful task.

How to use smart tags

When Excel recognizes types of data, the data is marked with a smart tag indicator, which is a purple triangle in the corner of a worksheet cell. To discover which actions you can take with a smart tag, move the insertion point over the cell that contains a smart tag indicator until the Smart Tag Actions button appears, and then click the arrow next to the button to see a menu of actions.

Smart tag indicators

Smart Tag Actions button

For example, if you type a U.S. financial symbol (such as MSFT) in a cell, the Smart Tag Actions button provides a list of smart tag actions that you can perform.

If you save an Excel workbook that contains smart tags as a Web page, you can perform tasks on the Web by using Microsoft Internet Explorer 5 or later. You can also use smart tags in your Microsoft Office Outlook e-mail messages and in Microsoft Office Word.

Two common examples

Obtaining detailed financial information and displaying your Outlook calendar are two common ways that you can use a smart tag.

Financial symbol

After typing a U.S. stock symbol (for example, MSFT) in a cell on a worksheet in Excel, you can use the smart tag options to gain instant access to published Web information about a company without having to open a separate Internet browser window.

For example, you can click a smart tag and then select the action Recent news on MSN MoneyCentral. The browser opens to a Web page that contains news and information about the company that you selected. When you are finished, you can close the browser and continue to work in Excel.

Outlook calendar

Another action that you can take is to display your Outlook calendar from a worksheet based on the date in a cell — without having to open and navigate to that date in Outlook.

Instead of navigating to a date in Outlook, type a date in an Excel worksheet, click the Smart Tag Actions button, and then select the action Show My Calendar. If Outlook is not already running, it is started, and the Outlook calendar opens to the date entered. If Outlook is already running, the calendar is immediately displayed.

How smart tags work

Excel recognizes certain types of data that it labels with smart tags. The type of actions that you can take depend on the data that Excel recognizes and labels with a smart tag. For example, if you type a valid stock symbol into a cell on an Excel worksheet, the symbol is recognized and given a smart tag that provides the following options:

• Insert refreshable stock price
• Stock quote on MSN Money Central
• Company report on MSN Money Central
• Recent news on MSN Money Central

The smart tag indicators appear in the cell on the worksheet as you type. They might also appear when you open a previously saved workbook.

 Note    Smart tags are turned on by default in Excel.

How to get more smart tags

On the Web, you can find additional smart tags that were created by Microsoft, by third-party companies, or by Information Technology (IT) professionals who design custom smart tags and actions for the specific products or services that you work with. For example, if you work in a sales department, you can click a custom "product name" smart tag in your document that offers actions such as "check quantity in stock" or "price."

 Note    The types of smart tags that come with Excel can vary depending on the language that is enabled.

 Top of Page

Use a smart tag

1. Make sure smart tags are turned on.

How to turn on smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.

The AutoCorrect dialog box appears.

3. Click the Smart Tags tab.
4. Select the Label data with smart tags check box.

Issue:  I don’t see any smart tags in the Recognizers list

1. On your computer's system disk, locate the following folder:

\Program Files\Common Files\Microsoft Shared\Smart Tag

2. Run the program SmartTagInstall.exe.
5. Click OK twice.
2. Move the insertion point over the purple triangle in a cell until the Smart Tag Actions button appears.
3. Click the arrow next to the button, and then select an action from the list.

 Top of Page

Change smart tag options

There are several smart tag options that you can specify to control the use of smart tags. The following procedures explain how to specify these options.

Turn on or off smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Select or clear the Label data with smart tags check box.

Change the smart tags indicator

You can choose to show the Smart Tag Actions button only, or show both the button and the purple triangle.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. In the Show smart tags as list, choose Button Only or Indicator and Button.

Check a workbook for new smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Select the Label data with smart tags check box.
5. Click Check Workbook to find all the smart tags (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.) in the workbook.

Hide smart tags

You can hide the smart tags (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.) from view in a workbook.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. In the Show smart tags as list, click None.

Save or discard smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Do one of the following:
   • To save all the smart tags (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.), select the Embed smart tags in this workbook check box.
   • To discard all the smart tags, clear the Label data with smart tags check box, and then clear the Embed smart tags in this workbook check box.
5. Close and reopen the workbook.

 Top of Page

Check for new smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Click More Smart Tags.

A Web page listing smart tags and actions is displayed in your Web browser (Web browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.).

 Top of Page

Remove smart tags

You can remove a single smart tag, some smart tags, or all smart tags in a workbook.

Remove a single smart tag from a cell

1. Move the insertion point over the cell until the Smart Tag Actions button appears.
2. Click the arrow next to the button, and then click Remove this Smart Tag.

Remove specific types of smart tags

This procedure removes some smart tags, but leaves the feature turned on.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Under Recognizers, clear the check boxes for the smart tags that you want to remove.
5. Click OK.
6. Close and reopen the workbook.

Remove all smart tags

You might want to remove smart tags because you have copied text that contains a smart tag from another document into your workbook, or smart tags might have been recognized in a document that was saved on someone else's computer.

Important  The following procedure removes all the smart tags, including the smart tags that are labeled by recognizers that you might no longer have on your computer and smart tags that are recognized in a document on someone else's computer. You cannot undo this action.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Proofing category, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, click the Smart Tags tab.
4. Clear the Label data with smart tags check box, and then clear the Embed smart tags in this workbook check box.
5. Close and reopen the workbook.

 Top of Page

Excel > Excel and the Web > Working with smart tags

Get a stock quote

Excel 2007

1. Make sure that smart tags (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.) are turned on.

How to turn on smart tags

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Proofing, and then click AutoCorrect Options.

The AutoCorrect dialog box appears.

3. Click the Smart Tags tab, and then select the Label data with smart tags check box.
   1. On your computer's system disk, locate the following folder:

\Program Files\Common Files\Microsoft Shared\Smart Tag

2. Run the program SmartTagInstall.exe.
4. Click OK twice.
2. Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Be sure to type the symbol in uppercase letters.
3. Click outside the cell.
4. Move your mouse pointer over the purple triangle in the lower-right corner of the cell, and then click the arrow next to the Smart Tag Actions button to see a list of options.
5. Click Insert refreshable stock price.
6. In the Insert Stock Price dialog box, choose whether to insert the stock price on a new worksheet or in a specific area of your current worksheet.

 Note    The data that is returned might fill a large portion of your worksheet.

Excel > Excel and the Web > Working with smart tags

Use smart documents

Smart documents are files, such as Microsoft Office Excel workbooks, that are programmed to give you help as you work with them. Several types of Excel files, such as forms and templates, can also function as smart documents.

What do you want to do?

Learn more about smart documents

Add and attach a smart document solution

Change the XML expansion pack that is attached to a smart document

Delete a smart document solution

Learn more about smart documents

Smart documents provide solutions to two common business problems: controlling business process workflow and reusing and sharing information. You add XML expansion packs to your Excel workbooks to create these smart document solutions. These solutions can be downloaded or they can be developed by using a Smart Document Software Development Kit.

Controlling business process workflow

Smart documents work especially well for workbooks that are part of a workflow. A workflow is the automated movement of documents or items through a specific sequence of actions or tasks related to a business process. Workflows can be used to consistently manage common business processes, such as document approval or review. For example, your company might have a process for filling out annual employee expense forms, and you might already use an Excel template for this purpose. If that template is converted into a smart document, it can be connected to a database that automatically completes some of the required information, such as employee name, employee number, and manager's name. When you complete the expense report, the smart document can display a button that allows you to send it to the next step in the workflow. Because the smart document "knows" who your manager is, it can automatically route itself to that person. And, no matter who has the document, the smart document knows where it is in the expense review workflow and what step needs to happen next.

Reusing and sharing information

You can use smart documents to help you share and reuse existing content. For example, attorneys can use existing boilerplate when they write contracts, and journalists can insert bylines and other frequently used text. Smart documents can also make it easier to share information, and can even interact with other Microsoft Office system programs. For example, you can use smart documents to send e-mail messages through Microsoft Office Outlook, all without leaving the document or starting Outlook yourself.

Adding smart document solutions by using XML expansion packs

When you add a smart document solution, it appears in the list of available solutions whenever you open a new smart document. To use a solution, you must first attach XML expansion packs to your document, which converts your Excel workbook into a smart document. An XML expansion pack contains multiple components, which include XML files and a manifest that references those components. When you open a document that is attached to an expansion pack, Excel also opens the Document Actions task pane. That task pane can include tools for completing tasks and help for using the smart document. The specific features that a smart document provides depend on the design that its creator — the developer or IT professional — implements. If necessary, contact your Information Technology (IT) professional for the location of and details about your smart document solution.

 Note    When you first use smart documents, you might see a message saying that you need to install the common language runtime components, or you that you need a different version of the components. If you see that type of message, contact your system administrator.

Downloading or developing smart documents

If you do not have development or IT resources available, you can download smart documents that were created by third parties. If you are a developer and you want to know more about how to create smart documents, see the Smart Document Software Development Kit on the Microsoft Developer Network (MSDN) Web site.

 Top of Page

Add and attach a smart document solution

1. If the Developer tab is not visible, do the following to display it:
   1. Click the Microsoft Office Button , and then click Excel Options.
   2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note    The Ribbon is part of the new Microsoft Office Fluent user interface – it replaces the multiple menus and toolbars with one easy place to find all of the commands that you need.

2. On the Developer tab, in the XML group, click Expansion Packs.

3. Click Add.
4. In the Install XML Expansion Packs dialog box, find the location of the manifest for the solution that you want to add.
5. Click Open.
6. In the Available XML expansion packs list, click the solution that you want to attach to your document, and then click Attach.

 Top of Page

Change the XML expansion pack that is attached to a smart document

1. If the Developer tab is not available, do the following to display it:
   1. Click the Microsoft Office Button , and then click Excel Options.
   2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note    The Ribbon is part of the new Microsoft Office Fluent user interface – it replaces the multiple menus and toolbars with one easy place to find all of the commands that you need.

2. On the Developer tab, in the XML group, click Expansion Packs.

3. Do any of the following:
   1. To remove the XML expansion pack's name and URL properties from the document, click Delete. The XML expansion pack will still be available in the Available XML expansion packs list.
   2. To replace the current XML expansion pack with the new XML expansion pack, in the Available XML expansion packs list, select a different XML expansion pack and then click Attach.
   3. XML expansion packs can be configured to update automatically at set intervals. To check for updates outside those intervals, click Update. If an updated XML expansion pack is available, the new components will be downloaded.

 Top of Page

Delete a smart document solution

1. If the Developer tab is not available, do the following to display it:
   1. Click the Microsoft Office Button , and then click Excel Options.
   2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note    The Ribbon is part of the new Microsoft Office Fluent user interface – it replaces the multiple menus and toolbars with one easy place to find all of the commands that you need.

2. On the Developer tab, in the XML group, click Expansion Packs.

3. In the Available XML expansion packs list, click the solution that you want to delete, and then click Delete.

 Note    Deleting a smart document solution removes the registry information for that solution. Deleting the solution does not remove any files that were installed on your computer by the XML expansion pack because another smart document may use those files.

 Top of Page

Excel > Excel and the Web > Working with smart tags

What are those buttons and triangles in my cells?

Excel 2007

In Microsoft Office Excel, there are seven options buttons and three colored triangles that can appear in or next to a cell. These buttons and triangles provide useful commands and information about the contents of the cell, and they appear at the moment you need them. This article describes what each of these buttons and triangles mean and how you can work with them.

In this article

Buttons that you might see on your worksheet

AutoCorrect Options

Paste Options

Auto Fill Options

Trace Error

Insert Options

Smart Tag Actions

Apply formatting rule to

Colored triangles that you might see in your worksheet

Green triangle

Red triangle

Purple triangle

Buttons that you might see on your worksheet

The seven buttons that can appear next to a cell are as follows: AutoCorrect Options, Paste Options, Auto Fill Options, Trace Error, Insert Options, Smart Tag Actions, and Apply formatting rule to.

AutoCorrect Options

The AutoCorrect Options button might appear when you rest the mouse pointer on the small blue box under text that was automatically corrected. For example, if you type a hyperlink or an e-mail address in a cell, the Autocorrect Options button might appear. If you find text that you do not want to be corrected, you can either undo a correction or turn AutoCorrect options on or off. To turn AutoCorrect options on or off, click the AutoCorrect Options button, and then make a selection from the list.

Paste Options

The Paste Options button appears just below your pasted selection after you paste text or data. When you click the button, a list appears that lets you determine how to paste the information into your worksheet.

The available options depend on the type of content that you are pasting, the program that you are pasting from, and the format of the text where you are pasting.

Auto Fill Options

The Auto Fill Options button might appear just below your filled selection after you fill text or data in a worksheet. For example, if you type a date in a cell and then drag the cell down to fill the cells below it, the Auto Fill Options button might appear. When you click the button, a list of options for how to fill the text or data appears.

The available options in the list depend on the content that you are filling, the program that you are filling from, and the format of the text or data that you are filling.

Trace Error

The Trace Error button appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left corner of the cell.

When you click the arrow next to the button, a list of options for error checking appears.

Insert Options

The Insert Options button might appear next to inserted cells, rows, or columns.

When you click the arrow next to the button, a list of formatting options appears.

Smart Tag Actions

The Smart Tag Actions options button might appear next to text that you type in a cell, such as a stock symbol or a person's name.

When you click the arrow next to the button, a list of actions that you can perform appears.

Apply formatting rule to

The Apply formatting rule to button is used to change the scoping method for conditional formatting data in a PivotTable report.

When you click the arrow next to the button, a list of scoping options appears.

 Top of Page

Colored triangles that you might see in your worksheet

The three colored triangles that can appear in a cell are green (error), red (comment), and purple (smart tag (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.)).

Green triangle

Red triangle

Purple triangle

Tip  The color of the error checking triangle indicator can be changed. Use the following procedure to change the color:

1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
2. Under Error Checking, select the Enable background error checking check box.
3. Click the Indicate errors using this color button, and then select a new color from the palette.

 Top of Page