Office 2013 Tip

by Linda Pearson, President of Summit Training

Tip for Excel, Word and PowerPoint 2013

MY ISSUE:

Every time I open Excel, Word, or PowerPoint the Start Window displays. From the Start Window I must choose a template to open. There are multiple templates to choose from including an empty worksheet for Excel, a blank document for Word, an empty presentation for PowerPoint.

MY PROBLEM:

I want to bypass the Start Window and go directly into the application.

THE FIX:

1. Open Excel, Word, or PowerPoint and get to a blank document. 
2. Click on the File tab.
3. From the menu on the left, choose Options.
4. By default the General option is selected.
5. At the bottom of the General window, within Start up options, remove the check from Show the Start screen when this application Starts.
6. Click on OK

ASK AMY: Filling a Shape with a Picture

After last month’s tip appeared (Cropping a picture to a Shape), I was asked if I could fill a shape with a picture. Here are the steps to accomplish that. This tips works in PowerPoint, Word, and Publisher:

1. Select the shape you want to fill with a picture and add it to your document. Select the shape so that it has selection handles displayed on each corner and each edge.

2. The Drawing Tools tab has been added to the tab line.

a. Click on it and from within the Shape Styles group.
b. Click on the Shape Fill button.  A gallery displays:

3. From the gallery,

a. Select Picture. The Insert Picture dialog box displays.
b. Navigate to where the picture you want to insert into the shape is saved.
c. Select it and click on the Insert button. The picture fills the shape.

Before:

 

After:

 

Ask Amy: Cropping a Picture to a Shape

Cropping a Picture to a Shape

These steps will work in Microsoft Word or PowerPoint version 2010

1. Select the picture to be cropped to shape. It will have round selection handles on each corner and square selection handles ion the middle of each side.
2. Click on the Picture Tools Format tab.
   
   
3. Perform the following steps:
1. Click on the bottom of the Crop button
2. From the drop-down menu, select Crop to Shape.
3. Make a Selection from the Shapes Gallery. In our example, we chose Trapezoid.

The picture will be cropped to the shape:

 

Ask Amy: Want to make the background to a picture transparent?

How to make the background to a picture transparent using MS Office

 

In Office 2010, you can do it in PowerPoint, Word, Publisher, and Excel.

• In Word:

Select the picture, click on the Picture Tools Format tab and then within the Adjust group, click on the Color button. From the menu at the bottom, select Set Transparent Color.  The mouse changes shape to something resembling a pencil. Click the mouse on the pictures background to make it transparent.

• In PowerPoint:

Select the picture, click on the Picture Tools Format tab and then within the Adjust group, click on the Color button. From the menu at the bottom, select Set Transparent Color. The mouse changes shape to something resembling a pencil. Click the mouse on the pictures background to make it transparent.

• In Publisher:

Select the picture, click on the Picture Tools Format tab and then within the Adjust group, click on the Recolor button. From the menu at the bottom, select Set Transparent Color.  The mouse changes shape to something resembling a pencil. Click the mouse on the pictures background to make it transparent.

• In Excel:

Select the picture, click on the Picture Tools Format tab and then within the Adjust group, click on the Color button. From the menu at the bottom, select Set Transparent Color. The mouse changes shape to something resembling a pencil. Click the mouse on the pictures background to make it transparent.

Different Ways to Display the Hidden Formatting Marks in Word

By Amy Pearson

There are two ways to display the hidden formatting marks placed into Word when keys such as the SPACE BAR, TAB, or ENTER keys are pressed.

Generally the hidden formatting marks are displayed by clicking on the Home tab and within the Paragraph group clicking on the Show/Hide button.  This method displays all the hidden formatting marks which include the ones listed above plus several others. The table explains the hidden formatting marks.

The first figure below shows how a portion of a document appears when the Show/Hide tool has been used to display the hidden formatting marks. Frequently, Word users want to see only the paragraph marks.  The second figure below side shows only the Paragraph marks displayed.

To display only Paragraph marks, take the following steps:

1. Click on the File tab (in Word 2007 click on the Office button).
2. From the Navigation bar, select Options (in Word 2007, click on Word Options). The Word Options dialog box displays.
3. From the Navigation bar, select Display.
4. From the Always show these formatting marks on the screen area, select Paragraph marks (Figure 2).
5. Click on the OK button. In the document only the hidden paragraph symbols are displayed.