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.
#How to change the backstage title for excel on mac mac#
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.