La Mecánica del Medio Continuo aplicada al tejido óseo

Custom headers and footers can be added to each spread- sheet. The headers and footers may include text, data from the workbook and computer, or graphics. To edit headers and footers, the worksheet must be displayed in Page Layout view. The Page Layout view is displayed by clicking on the

Page Layout button located on the Status bar (shown in

Figure 3-53) or by clicking on the View menu tab and click- ing on the Page Layout button in the Workbook Views group (shown in Figure 3-54). Once the spreadsheet is in Page Layout view, the user can click on the header or footer to edit the header or footer. Alternately, the user may click on the Insert menu tab and click on the Header & Footer but- ton in the Text group (shown in Figure 3-55) to switch to the Page Layout view and open the header and footer for editing.

FIGURE 3-53 Page Layout Button

FIGURE 3-54 View: Page Layout Button

The headers and the footers are divided into three areas: left (for left-justified elements), center (for centered elements), and right (for right-justified elements). A sam- ple header is shown in Figure 3-56. It is important to note that elements in any of these areas are not limited to their areas. They simply identify how the element is aligned. Text is typed in the headers or footers and the font is changed in the same manner as the font in the cells is changed. When the header or footer has been selected, the Header & Footer Tools: Design menu tab become visible. Elements are added to the header and footers by clicking on the Header & Footer Tools: Design tab and selecting the appropriate element from the Header & Footer Elements group. The elements of the Header & Footer Elements group, along with an explanation of their use are shown in Figure 3-57.

The Page Number button is used to automatically num- ber the pages. The Number of Pages button is used to display the total number of pages in the worksheet. This, along with the Page Number button, allows the user to number the pages “1 of 5,” “2 of 5,” and so forth. By numbering the pages in this manner, it is easy to see if pages at the end of the doc- ument are missing.

The Current Date button adds the current date from the computer to the header or footer. The Current Time button adds the current time from the computer to the header or footer. The date and time will be automatically updated when the worksheet is printed. By putting the date and time on each worksheet, it is easy to determine which printed ver- sion of the worksheet is the most current. This is very useful when preparing bids and the user wants to make sure he or she is using the most current worksheet.

The File Path button adds the file name and path (the location of the folder) to the header or footer. This is useful when trying to locate the computer file for a worksheet that has been printed. The File Name button adds just the file name to the header or footer. The Sheet Name button adds the name on the worksheet tab to the header or footer.

The Insert Picture button brings up the Insert Picture dialogue box, which allows the user to add a picture, such as the company’s logo, to the worksheet. The Insert Picture dia- logue box is shown in Figure 3-23. Pictures are added to the headers and footers in the same manner as pictures are added to the worksheet. The Format Picture button brings up the Format Picture dialogue box, which allows inserted

FIGURE 3-56 Header

FIGURE 3-57 Elements Available to Headers and Footers

Icon Name Use

Page Number Adds the page number to each page of the header or footer.

Number of Pages

Adds the total number of pages in the header or footer.

Current Date Adds the current date from the computer to the header or footer.

Current Time Adds the current time from the computer to the header or footer.

File Path Adds the file name and path (location of the folder) to the header or footer.

File Name Adds the file name to the header or footer.

Sheet Name Adds the name on the worksheet tab to the header or footer.

Picture Brings up the Picture dialogue box that is shown in Figure 3-23, which allows pictures to be added to the header or footer. Format Picture Allows inserted pictures to be

pictures to be resized, rotated, and cropped. The Format Picture dialogue box is shown in Figure 3-58.

The user may move from the header to the footer by clicking on the Header & Footer Tools: Design menu tab and clicking on the Go to Footer button (shown in Figure 3-59) and from the footer to the header by clicking on the Header

& Footer Tools: Design menu tab and clicking on the Go to Header button (shown in Figure 3-60).

Once the header and footers have been set up the user clicks on a cell in the worksheet to close the header or footer and return to editing the worksheet. The user may return to the Normal view by clicking on the Normal button located on the Status bar (shown in Figure 3-61) or by clicking on the View menu tab and clicking on the Normal button in the Workbook Views group (shown in Figure 3-62).

FIGURE 3-58 Format Picture Dialogue Box

FIGURE 3-59 Header & Footer: Design: Navigation: Go to Footer Button

FIGURE 3-60 Header & Footer: Design: Navigation: Go to Header Button

FIGURE 3-61 Normal Button on the Status Bar

FIGURE 3-62 View: Normal Button

Exercise 3-5

In this exercise you will modify the file from Exercise 3-4 by adding headers and footers to the Detail worksheet. In the header you will add the sheet name. In the footer you will add the date and time (which will record the date and time the spreadsheet is printed), the file location, the page num- ber, and a place for the preparer and reviewer to initial. Begin by adding a header using the following steps:

1. Make sure that Chapter 03, the workbook created in Exercise 3-1, is open.

2. Click on the Insert menu tab and click on the Header &

Footer button (shown in Figure 3-55) to edit the header.

3. Place the cursor in the center section and click the Sheet

Name button from the Header & Footer Elements

group. The Header should look like Figure 3-56. When the cursor is moved from the center section of the header, the &[Tab] will be replaced with the name of the tab, in this case Detail.

Next, add a footer using the following steps:

4. Right click on the Go to Footer button from the Navigation group (see Figure 3-59) to move to the footer. 5. Place the cursor in the right section and type Prepared

by: followed by pressing the Underline key ten times.

6. Press the Return key and type Checked by: followed by pressing the Underline key ten times.

7. Place the cursor in the center section and click the Page

Number button from the Header & Footer Elements

group.

8. Following “&[Page]” type of, including a space before and after the of.

9. Click the Number of Pages button from the Header & Footer Elements group and press the Enter button to move it up one line.

10. Place the cursor in the left section, click the Current

Date button from the Header & Footer Elements group,

type the Space bar, and click the Current Time button from the Header & Footer Elements group.

11. Press the Enter key to move to the following line and click the File Path button from the Header & Footer Elements group.

12. The Footer should look like Figure 3-63. When the cur- sor is moved from the left section of the footer, the &[Date] &[Time] will be replaced with the current date and time and the &[Path]&[File] will be replaced with the path and file name.

13. Click on any cell to return to the worksheet.

14. Click on the View menu tab and click on the Normal button (shown in Figure 3-62) to return to the Normal view.

15. Save the workbook by clicking on the Save button on the Quick Access toolbar or typing Ctrl+S.