Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Insert Tab

EXCEL 2010 INSERT RIBBON

Text

EXCEL 2010 TEXT GROUP

The Text section of the Insert tab allows you to insert text boxes, WordArt and the other buttons show in the image to the left. We will review each of these functions, so we can show you how to enhance your worksheet.

The first function, Text Box, allows you to insert a text box that can be positioned anywhere on the page. Click on the Text Box button and click and drag to form a box in your document. Your cursor will be in the box and you can start typing. You can move the box anywhere in the document and resize it as needed.

In the image below, you can see the text box we added to the bottom of the worksheet.

EXCEL 2010 INSERT TEXT BOX

The Text section also includes the Header & Footer function which will allow you to add a new one or edit your existing Header & Footer. Select the Header & Footer button and your worksheet will look similar to ours as seen in the image below. Notice a Header & Footer Tools Design tab has been added to the ribbon along with a blank header showing at the top of the worksheet.

EXCEL 2010 INSERT HEADER AND FOOTER

Headers and footers are only displayed in Page Layout view, Print Preview and on printed pages.

You can manually type in your header or select Header from the Header & Footer section of the Design tab. As shown in the image below, you can select from the numerous built in headers and footers.

EXCEL 2010 INSERT HEADER AND FOOTER





For our example, we will select the bottom built in header from the drop down menu, Prepared by Sommer 6/2/2019, Page 1.

Review the image below to see how the header appears in our worksheet.

EXCEL 2010 INSERT HEADER
EXCEL 2010 INSERT HEADER AND FOOTER ELEMENTS

The Header & Footer Elements section of the Header & Footer Tools Design tab allows you to add Page Numbers, Number of

Pages, Current Date, Current Time and more to your header or footer. Simply select the field within the header or the footer where the information should go and click on the desired function.

EXCEL 2010 HEADER AND FOOTER NAVIGATION

The Navigation section of the Header & Footer Tools Design tab will allow you to quickly navigate to the header and footer section.

EXCEL 2010 HEADER AND FOOTER TOOL OPTIONS

The Options section of the Header & Footer Tools Design tab includes the functions to the left.

·         Different First Page: Specify a unique header and footer for the first page of the document.

·         Scale with Document: Specify whether the header and footer should scale as you use the “Shrink To Fit” feature on the document.

·         Different Odd & Even Pages: Specify that odd numbered pages should have a different header and footer from even-numbered pages.

·         Align with Page Margins: Align the sides of the header or footer to the page margins.

EXCEL 2010 INSERT WORDART



WordArt allows you to insert decorative text into your document.

Click on WordArt in the Text section of the Insert tab and a drop-down menu will show the different variations of WordArt.

Click on your selection and the text box will appear. Anything you type will be formatted in the WordArt you selected.

Move or resize the text box as needed.

EXCEL 2010 INSERT SIGNATURE LINE


If your document needs signed, you can insert a Signature Line. Click on the Signature Line button in the Text section. From the drop-down menu, select Microsoft Office Signature Line. A Signature Setup dialog box will appear, as shown in the image to the left.

Complete the fields and select OK.

EXCEL 2010 INSERT SIGNATURE LINE





The signature line will be inserted into your document. You can move and resize it as needed.

To insert an embedded object into your worksheet, select the cell where you want the object. Locate the Text section in the Insert tab and select the Object button. The insert dialog box will appear.

EXCEL 2010 INSERT EMBEDDED OBJECT



In the Object type box, we are going to scroll down and select Microsoft Word Document. For this example, we are not going to check the Display as icon box. Select OK after making your selections.

As you can see in the image below, an open Word document has been embedded into your worksheet. You can move or adjust the size of your Word document as needed.

EXCEL 2010 INSERT EMBEDDED OBJECT
EXCEL 2010 INSERT EMBEDDED OBJECT



We are now going to embed the Word document as an icon. Select a cell in your worksheet, and then select Object from the Text section. This time in the Object dialog box, select Microsoft Word Document and check the Display as icon box. Click OK when finished.

A new, blank Word Document will open. Once you have completed your document, save and close it. You will now see an icon in your worksheet, which represents your Word Document (as shown in the image below). Simply click on the icon to open the Word Document.

EXCEL 2010 INSERT EMBEDDED OBJECT
Next Tutorial


This concludes the Text tutorial.
Click next to continue to the Excel 2010 Symbols tutorial.