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
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
• 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
Page margins set
To set page margins:
• Click the Margins button on the Page Layout tab
• Choose one of the options offered, or
• Click Custom Margins
• Complete the page margin setting dialog
• Click OK.
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)
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
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 .