MS Excel 2007 - Lesson 13: Format sheets and prints
TipsMake.com - Set up printing labels
The Print Titles function allows you to repeat the column and line headings at the beginning of each new page to read more pages than to read when printing. To set up Print Titles:
• Click the Page Layout tab on the Ribbon
• Click the Print Titles button
• In the Print Titles section, click the box to select the row or column to be repeated
• Select the row or column
• Click the Select Row / Column button
• Click OK
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 1
Create Header and Footer
To create a header or footer:
• Click the Header & Footer button on the Insert tab
• Now, the Design tab for Header & Footer will appear on the Ribbon
• To switch between Header and Footer, click the Go to Header or Go to Footer button
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 2
• To insert text: enter text into the header or footer
• To enter pre-programmed data such as page number, date, time, file name or sheet name. Click the appropriate icon
• To change the location of the data, click to select the cell you want
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 3
Page margins set
To set page margins:
• Click the Margins button on the Page Layout tab
• Choose one of the options offered, or
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 4
• Click Custom Margins
• Complete the page margin setting dialog
• Click OK.
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 5
Change page orientation
To change the page orientation from vertical to horizontal:
• Click the Orientation button on the Page Layout tab
• Choose Portrait or Landscape (horizontal)
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 6
Set page breaks
You can set page breaks in a spreadsheet to read sheets easily when printing. To set up page breaks:
• Click the Breaks button on the Page Layout tab
• Click Insert Page Break
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 7
Print a region
You may want to print only part of a spreadsheet. This work is done easily through the Print Range function. To print a region:
• Select the printed area
• Click the Print Area button on the Page Layout tab
• Click Set Print Area .
MS Excel 2007 - Lesson 13: Format sheets and prints Picture 8
You should read it
- Create header and footer in Excel
- How to create Header in Microsoft Excel
- How to insert underlined Header and Footer Excel
- MS Word - Lesson 11: Format the page
- How to create a page header (Header) and footer (Footer) in Word
- How to page numbering and create Header, Footer in odd and even pages in Word 2007 and 2010
- How to Add Header Row in Excel
- Create Header and Footer for text page in Word
- Microsoft Word: How to create page title (Header) and footer (Footer)
- MS Excel 2007 - Lesson 7: Create Macros in Excel 2007
- MS Excel 2007 - Lesson 2: Customizing in Excel
- How to print Excel on an A4 page