You can turn your Microsoft Office files into HTML documents that you can post on the Web. When you activate the Save As Web page command, you create a Web page file that contains all of the necessary HTML coding for it to be read by Web browsers.

Create an HTML File

Tip

What does the Publish button do?

If you are turning an Excel worksheet or PowerPoint slide into a Web page, and you are ready to publish the Web page to a server, you can click Publish in the Save As dialog box to open the Publish as Web Page dialog box. You can then use the Publish as Web Page dialog box to add spreadsheet functionality to the page and designate a server path and filename. When you activate the Publish command, Office publishes the page and opens it in your default browser to display the information.

Can I assign a password to a workbook?

Yes. You can assign a password from the Save As dialog box. Simply click the Tools button and click General Options. This opens the General Options dialog box. Type a password for the file and click OK. Then retype the same password again to verify it. When you save the file, the password is saved along with the workbook. You can also use the General Options dialog box to add a password that allows other users who know the password the opportunity to change the file.

You can insert hyperlinks into your files that open a Web page when a user clicks them. When linking to a Web page, you must designate a Uniform Resource Locator, or URL. This is the unique address that identifies the Web page.

You can also use hyperlinks to link to other files on your computer. You must designate the address or path of the page that you want to link to when you add links to a file.

Add a Hyperlink

Tip

How do I edit a link?

To change a link, such as editing the Web page URL, you can open the Edit Hyperlink dialog box and make any necessary changes. Right-click the link and click Edit Hyperlink from the shortcut menu. The Edit Hyperlink dialog box appears. You can use the dialog box to change the hyperlink text and address, or the type of page that you want to use in the link.

How do I remove a hyperlink?

You can right-click a link and click Remove Hyperlink from the shortcut menu. The associated link is removed and the original text or image remains. To remove a hyperlink from the Edit Hyperlink dialog box, you can click Remove Link.

You can use AutoShapes to draw your own shapes and graphics for your documents, worksheets, slides, and publications. You can choose from a large library of predrawn shapes in the AutoShapes palette. Once you draw a shape, the Format tab displays the Drawing tools that you can use to format the shape, including tools for controlling the color and line thickness.

AutoShapes is just one of several features that you can find on the Insert tab on the Ribbon in Word, Excel, and PowerPoint. You can also use AutoShapes in Publisher. Graphics tools are not available in Outlook or Access.

Draw AutoShapes

Tip

How do I add text to an AutoShape?

To add text to a shape, you can click the Edit Text button on the Format tab that appears on the Ribbon when you select the shape. After you type your text, you can format it with the formatting tools found on the Home tab of the Ribbon. When you activate the Edit Text tool, the AutoShape converts to a text box object.

How do I remove an AutoShape?

You can easily delete any AutoShape object that you add to a document. Simply click the shape to select it, and then press

You can add interest to your Office files by inserting clip art images. Clip art is simply predrawn artwork. Word, Excel, PowerPoint, and Publisher install with the Office clip art collection. In addition, you can look for more clip art on the Web using the Clip Art task pane.

Insert Clip Art

Tip

How do I search for a particular type of clip art, such as a photo or sound file?

To search for a particular type of media, click the Results should be

How do I find details about the clip art?

To find out more about the clip art's properties in the Clip Art task pane, move

You can use the Microsoft Clip Organizer to view clip art collections on your computer. You can also insert clip art from the Organizer window and place it in your Office file. The Clip Organizer does exactly as its name implies — it organizes clip art images and entire clip art collections to suit the way you work. For example, you might place all of the clip art related to your company newsletter in one collection.

View Clip Art with the Clip Organizer

Tip

How do I download clip art from the Web?

You can click the Clip art on Office Online link at the bottom of the Clip Art task pane to open your default Web browser to the Office Web site. From there, you can click a clip art category and locate the art that you want to download. Simply select the images that you want to download, click the Download link, and follow the instructions.

Can I copy clip art from one collection to another?

Yes. You can copy clip art from one collection and paste it into another collection using the Microsoft Clip Organizer. Simply click the clip art that you want to copy, and then use the Copy (

You can illustrate your Office files with images that you store on your computer. For example, if you have a photo or graphic file from another program that relates to your Excel data, you can insert it onto the worksheet. If you have a company logo, then you can insert it onto a Word document.

Image or picture files, also called objects in Office, come in a variety of file formats, such as GIF, JPEG or JPG, and PNG. After you insert an image, you can resize and reposition it, as well as perform other types of edits on the image.

Insert a Picture

Tip

If I am sharing my file with others, can I compress the pictures to save space?

Yes. You can take advantage of the new compression features available in Office 2007 to compress image files that you add to any document. Simply select the picture and display the Format tab on the Ribbon. In the Picture Tools group of commands, click the Compress Pictures button. This opens the Compress Pictures dialog box. Click the Options button to open the Compression Settings dialog box, and fine-tune any settings that you want to apply. Click OK, and then click OK again to compress the pictures.

I made changes to my picture, and now I do not like the effect. How do I return the picture to the original settings?

You can click the Reset Picture button, located in the Picture Tools group on the Format tab, to restore a picture to its original state. This command removes any edits that you applied to the image. Activating this command does not restore the original size of the image.

You can quickly add a border to any picture or clip art image using the Picture tools. You can choose a border color from among the many theme and standard color selections. You can also assign a line weight to the border to make thin or thick borders.

Add a Picture Border

Note

To set a border in Publisher, click the Line/Border Style button (

You can use the new Picture Effect tool to assign unique and interesting special effects to your pictures and clip art graphics. For example, you can make the edges of an image seem to glow, or create a mirrored reflection effect.

Keep in mind that the Picture Effects tool is not available in Publisher.

Add a Picture Effect

You can use the WordArt feature to turn text into interesting graphic objects to use in your Office files. For example, you can create arched text to appear over a range of data in Excel, or vertical text to appear next to a paragraph in Word. You can create text graphics that bend and twist, or display a subtle shading of color.

In Word, the WordArt feature works the same as in previous versions of Office. In PowerPoint and Excel, the feature works a bit differently, as shown in this task.

Insert a WordArt Object

Tip

How do I edit my WordArt text?

To edit the WordArt text, simply click the WordArt text box and select the text that you want to change. When you type your changes, the object immediately reflects the new text. To edit the appearance of the WordArt object, use the WordArt Styles tools, located on the Format menu on the Ribbon.

How do I remove a WordArt object?

To remove the object entirely, click the WordArt text box, and then press

You can move and resize any clip art, image, or shape that you place in a file. Clip art, images, and shapes are also called objects in Office. When you select an object, it is surrounded by handles that you can use to resize it.

Move and Resize an Object

MOVE AN OBJECT

RESIZE AN OBJECT

Tip

Can I also use the Cut, Copy, and Paste commands to move or copy an object?

Yes. You can easily cut, copy, and paste objects around your Office files. Simply select an object and then apply the commands. You can find the commands on the Home tab on the Ribbon in Word, Excel, and PowerPoint. In Publisher, you can click

Can I resize an object and keep the scaling proportional?

Yes. To maintain an object's height-to-width ratio when resizing, press and hold

You can rotate and flip objects that you place on your documents, worksheets, slides, or publications to change the appearance of the objects. For example, you might flip a clip art image to face another direction, or rotate an arrow object to point elsewhere on the page.

Rotate and Flip Objects

ROTATE AN OBJECT

FLIP AN OBJECT

Tip

How do I rotate text?

The easiest way to rotate text is to create a WordArt object to rotate. You can learn how to create a WordArt object in the "Insert a WordArt Object" task, earlier in this chapter. After you create the WordArt, you can rotate it using the steps shown in this task. You can also choose from several preset vertical text styles among the WordArt styles.

Is there a way to constrain how much rotation occurs when I drag the rotation handle?

Yes. To constrain the rotation to 15-degree angles, press and hold

You can crop a picture that you add to any Office file to create a better fit or to focus on an important area of the image. The Crop tool, located on the Format tab, can help you crop out parts of the image that you do not need. You can also crop clip art pictures.

Crop a Picture

Tip

How can I reduce the overall file size of an image that I use in an Office file?

Image files are notorious for consuming large amounts of file space, and when you insert a large image into a document or worksheet, it adds to the size of the file. You can use the Compress Pictures tool on the Ribbon's Format tab to reduce the resolution of an image or to discard extra information from cropping the image. Click the Compress Pictures button to open the Compress Pictures dialog box, and then click the Options button to open the Compression settings dialog box, which offers several options to help you to control the overall file size of an image.

How can I return the image to its original state before cropping?

You can click the Reset Picture button in the Format Picture dialog box to reset the image to the size it appeared when you first inserted it onto your worksheet. Any cropping or other edits that you made to the image are discarded. Click the Size button, which is located in the bottom right corner of the Size command group on the Ribbon. The Size dialog box appears. Click the Reset button on the Size tab to resize the image.

You can add shadow and 3-D effects to your AutoShapes, lines, arrows, and any other shapes that you create. You can also add shadow and 3-D effects to clip art and picture objects that you insert into a document. Adding shadow and 3-D effects can give an object the illusion of depth on the page.

Add Shadow and 3-D Effects

ADD A SHADOW

ADD A 3-D EFFECT

Tip

Is there a way to fine-tune a shadow effect?

Yes. You can click the More Shadows link, at the bottom of the Shadow palette in the Shape Effects or Picture Effects menu, to access the Format dialog box. Click the Shadow category in the dialog box to find options to adjust the shadow effect. These options include several settings for changing the angle and distance of the shadow effect. The dialog box also includes a button for changing the color of the shadow effect. You can experiment with the options to create just the right shadow for your object.

Can I edit the way in which my 3-D effect is applied to a shape?

Just like the shadow effect, you can fine-tune the 3-D effect using the 3-D Format category in the Format dialog box. Click the Shape Effects or Picture Effects button on the Format tab, click 3-D Rotation, and then click More 3-D Settings. The dialog box includes a category for adjusting the rotation settings and the 3-D format.

You can control the placement of objects, such as AutoShapes, in your document to create different kinds of effects. For example, you might layer two shapes on top of each other to create a logo, or you might group several shapes together in order to move them around the document more easily.

Arrange Objects

CHANGE OBJECT ORDER

GROUP OBJECTS

Tip

How do I align shapes?

You can use the Align controls in the Format tab of the Ribbon to align and distribute shapes evenly on the page. For example, you might want to line up three shapes on the left side of a document. To do so, select the first shape, and then press and hold

Is there another way to select and group multiple objects?

Yes. If you have several objects scattered around a page, you can drag a selection handle around them to create a group. Simply click and drag across the page to include each object in the selection rectangle. When you release the mouse button after dragging across the objects, the objects are automatically grouped for you.

You can control the way in which your document's text wraps around any object that you place on a page. For example, you might want the text to wrap tightly around a clip art graphic, or to make the text appear to overlap a shape.

Control Text Wrapping

You can use the Recolor command to quickly recolor a clip art object or a picture. For example, you might want to choose a color that matches the other elements in your document. You can choose from several preset color modes, in light and dark variations.

Recolor a Picture

You can use the SmartArt feature to create all kinds of diagrams to illustrate concepts and processes. For example, you might insert an organizational diagram in a document to show the hierarchy in your company, or you might use a cycle diagram to show workflow in your department.

Add SmartArt

Tip

Can I resize my diagram?

Yes. The diagram is an object that you can move and resize just like other objects in the Microsoft Office programs. To move or resize a diagram, see the "Move and Resize an Object" task. You can also use the control on the Diagram toolbar to change the sizing of the diagram layout, such as fitting the diagram to the contents or expanding the chart. Click Layout on the Diagram toolbar to view your options.

Can I change a shape's position or shape in the diagram?

Yes. To change the position, click the shape element in the diagram, and then click the Promote or Demote button in the Create Graphic group on the Design tab. To change the shape to a new shape, first click the shape to select it, then click the Format tab and click the Change Shape button in the Shape Styles group.