Sunday, December 21, 2008

Tip # 43 Easy data-posting to the Web

If your organization is using an intranet to share public data—and whose organization isn't these days—your users will want an easy way to post this information. Excel 97 offers an easy, wizard-driven system to walk even the most apprehensive users through this process:
1. Select the cell range that contains the data to be published.
2. Select Save As HTML from the File menu.
3. Answer the questions posed by the Internet Assistant Wizard.
The wizard walks users through four steps that define how information will be converted for Web display. Various options include:
• Inserting the resulting HTML tables into an existing HTML page or creating an entirely new page.
• Specifying formatting options, such as rules between data.
• Saving the new HTML page as a freestanding file or inserting it directly into a FrontPage Web.