Page Properties and Printing
Set Print Titles
The print titles function allows you to repeat the column and row headings at the beginning of each new page to make reading a multiple page sheet easier to read when printed. To 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 rows/columns to be repeated
- Select the row or column
- Click the Select Row/Column Button
- Click OK

Create a Header or Footer
To create a header or footer:
- Click the Header & Footer button on the Insert tab
- This will display the Header & Footer Design Tools Tab
- To switch between the Header and Footer, click the Go to Header or Go to Footer button

- To insert text, enter the text in the header or footer
- To enter preprogrammed data such as page numbers, date, time, file name or sheet name, click the appropriate button
- To change the location of data, click the desired cell

Set Page Margins
To set the page margins:
- Click the Margins button on the Page Layout tab
- Select one of the give choices, or

- Click Custom Margins
- Complete the boxes to set margins
- Click Ok

Change Page Orientation
To change the page orientation from portrait to landscape:
- Click the Orientation button on the Page Layout tab
- Choose Portrait or Landscape

Set Page Breaks
You can manually set up page breaks in a worksheet for ease of reading when the sheet is printed. To set a page break:
- Click the Breaks button on the Page Layout tab
- Click Insert Page Break

Print a Range
There may be times when you only want to print a portion of a worksheet. This is easily done through the Print Range function. To print a range:
- Select the area to be printed
- Click the Print Area button on the Page Layout tab
- Click Select Print Area

// Related Posted - GOOGLE!
Loading
Related Websites
- Top 100 Tools and Resources for YouTube [/caption] YouTube is still the undisputed king of video sharing on the web, so it only makes sense that there...
- Search Engine Optimization Keyword Analysis Keyword analysis is an important part of search engine optimization or SEO, because your keywords will play a vital role...
- iGoogleAnalytics Bringing webmaster tools to your desktop So you like Google, have iGoogle as your home page and, use Google’s webmaster...
- Favorite Wordpress Plugins This article is about plugins for the Wordpress blogging platform. Â If you aren't a blogger, this article may not be...
- How to add the button "I like" Facebook post to Wordpress One of the latest novelties from Facebook is the button "I like" that anyone with a website can add their...
