Using the Page Layout Tab in Excel 2007
Tip: If you are unsure what the function of a feature is, let your cursor hover over the button (in Excel) to see a pop-up box explaining the feature. If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab.
Themes Themes - Change the overall design of the entire document, including colors, fonts, and effects. Colors - Change the colors for the current theme. Fonts - Change the fonts for the current theme. Effects - Change the effects for the current theme.
Page Setup Margins - Select the margin sizes for the entire document or the current selection. Orientation - Switch the pages between portrait and landscape layouts. Size - Choose a paper size for the current section. To apply a specific paper size to all sections of the document, click on More Paper Sizes . Print Area - Mark a specific area of the sheet for printing. Breaks - Specify where a new page will begin in the printed copy. Page breaks are inserted above and to the left of the selection. Background - Choose an image to display as the background of a sheet. Print Titles - Specify rows and columns to repeat on each printed page. Diagonal Arrow - Click on the arrow in the bottom right corner of Page Setup to see the Page Setup dialog box (Page tab selected, three other tabs are available)
Scale to Fit Width - Shrink the width of printed output to fit a maximum number of pages. Height - Shrink the height of printed output to fit a maximum number of pages. Scale - Stretch or shrink the printed output to a percentage of its actual size. The maximum width and height must be set to "Automatic" to use this feature. Diagonal Arrow - Click on the arrow in the bottom right corner of Scale to Fit to see the Page Setup dialog box (Page tab selected, three other tabs are available)
Sheet Options Gridlines - Show, or hide, the lines between rows and columns in the sheet. Showing makes numbers in columns or rows easier to read or edit. Hiding gridlines is useful if you are making a graphic organizer in Excel. These lines will not print unless the Print box is checked. Headings - Show row and column headings. Row headings are the row numbers on the side of the sheet that range from 1 to 1,048,576. Column headings are the letters that appear above the columns on a sheet that range from A to XFD. This is also found on the View tab of an Excel Workbook. Diagonal Arrow - Click on the arrow in the bottom right corner of Sheet Options to see the Page Setup dialog box (Sheet tab selected, three other tabs are available)
Arrange Bring to Front - Bring the selected object in front of all other objects so that no part of it is hidden behind another object. Send to Back - Click here to send the selected object back one level or to the back of all objects. Selection Pane - Show the Selection Pane to help select individual objects and to change their order and visibility. Align - Align the edges of multiple selected objects. You can also center the objects or distribute them evenly across the page. Group - Group objects together so that they can be treated like a single object. Rotate - Rotate or flip the selected object.
In the Table below, select which section of the Layout tab you would use to perform the stated action.
During an Internet4Classrooms training session you learned how to make concept maps in Excel 2003. You are ready to try it in Excel 2007 and want to remove the gridlines before starting. What area of the Page Layout tab do you use?
On the concept map that you made, you drew many shapes and several of them overlap. You want to change the order of the overlap, which area of Page Layout do you go to?
You want to put an image in the background of a worksheet to make a review activity. Which area of the Page Layout tab will let you do this?
You have drawn a shape and want to rotate the shape to teach transformation in math class. WHich section of Page Layout can be used to do this?
You do not want to print a whole page, just a part of one. What ares of the Page Layout tab will allow you to set area to be printed?
You want to clean up the look of a worksheet by removing those letters across the top and the numbers down the left side. Where do you go to do that?