The dialog box shown in Figure 3.28 should appear. Click the Print Titles button in the Page Setup group on the ribbon.Exit Backstage View then click the Page Layout tab on the ribbon.To set Print Titles you need to exit Print Preview. You are going to use Print Titles to repeat the first three rows of the worksheet on each of the printed pages. All of the columns are now on the same page, but the second and third pages have no column labels to identify what information is in each column. This fits all of the columns on one page. Change the Orientation from Portrait to Landscape.
NUMBER DIALOG BOX LAUNCHER EXCEL MAC MAC
The worksheet is currently printing on four pages ( Mac users may only see three pages but that is ok), with the City and Sizes columns printing on separate pages from the rest of the data. Mac Users: choose File from the Menu Bar, and then choose Print
With the CH3-Gradebook and Parks file still open, and the Parks tab selected, go to Backstage View by clicking the File tab on the ribbon. You will notice that the worksheet is printing on multiple pages, and you cannot tell what each column of data represents on some of the pages. Now that you have fixed the cell and text formatting, you are ready to review the worksheet in Print Preview. Click OK.įigure 3.27 Font Tab in Format Cells Dialog Box Repeating Column (and Row) Labels In the Effects section of the Format Cells dialog box, check the box for Superscript (see Figure 3-27). Instead, choose Format from the Menu Bar, click Cells: then continue with Steps 4 and 5 Mac Users: there is no dialog box launcher for Excel for Mac. On the ribbon (Home tab) click the dialog box launcher arrow in the Font group. Select just the 2 (be careful not to select anything else). Double-click on cell E3 to enter Edit mode. The next new formatting skill is to change the label in E3 from Size (km2) to Size (km 2) with the 2 after km formatted with superscript. Notice that the names of the states are now centered between the top and bottom borders of the cells. In the Alignment group, click the Middle Align button (see Figure 3.26). Select A4:A43 (the cells with the state labels). You are going to start by vertically aligning the names of the states within the cells. Now that you have fixed the inconsistencies in the formatting, you decide to apply some formatting techniques to make the worksheet look even better. Now right-click the “ Grades” sheet tab, point to Tab Color and choose an “ orange” color. Point to Tab Color and choose a “ blue” color. Right-click the “Park Size” sheet tab ( Mac users hold down Ctrl key and click the sheet tab). The use of colored tabs assists in navigating between sheet tabs. Finally, let’s add color to the two sheet tabs. While you’re fixing errors, proofread the sheet and correct any typos. Use Increase Decimal and/or Decrease Decimal until one digit appears after the decimal place for all values. Apply the green fill color to A31:E31 (be sure to match the green fill color of the other states). Change the font size to 16 and apply Bold format. To fix these errors, complete the following steps:. Also, these values should be formatted with Comma style to make them easier to read. The number of digits after the decimal place for the Size values is inconsistent. The cells for the Nevada data should have the same green fill color as the other alternating states. The Year Established values for Hawaii are not center aligned like the other years. The formatting of the Utah label does not match the other states. Scroll through the worksheet and locate the following formatting errors:. The first thing you are going to do is review the worksheet for formatting inconsistencies. Figure 3.26 Completed National Parks worksheet Reviewing Formatting for Inconsistencies Figure 3.26 shows how the second page of the finished worksheet will appear in Print Preview. You also need to prepare it for printing. Your coworker formatted the workbook and has asked you to review it for consistency. 
You have been given a spreadsheet with data about the national parks in the western United States. Open the “CH3-Gradebook and Parks” workbook if it isn’t already open.Ĭlick on the “Park Size” sheet tab within your “CH3-Gradebook and Parks” workbook. A new data file will be used for this section. This worksheet currently prints on four pages, so we will learn new page setup options to control how these pages print. In this section, we will review a worksheet for formatting consistency, as well as learn two new formatting techniques.
Control where page breaks occur in a multiple page worksheet. 
Use Print Titles to repeat rows and columns on each page of a multiple page worksheet.Locate and fix formatting consistency errors.
0 kommentar(er)
