Page Properties and Printing

Page Properties and Printing

Set Print Titles
The print titles function allows you to repeat the column and row headings atthe 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 orfooter:

§     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 Footebutton
§     To insert text, enter the text in the header or footer
§       To enter preprogrammed data such as pagenumbers, 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 aportion of a worksheet. This is easily done through the Print Range functionTo print a range:

§     Select the area to be printed
§     Click the Print Area button on the Page Layout tab
§     Click Select Print Area




    Category List

    • 3D Animation Video
    • 3D presentation
    • 3G
    • 3G Data Cards
    • 5 Essential Diet Tips
    • A Way to Earn $100 A Day..Capitalize on FaceBook
    • Accessories
    • Adsense
    • Amazon
    • Android
    • Apple
    • Approval
    • Article
    • basic I.T
    • best ways of burning fat
    • Bike
    • biomedical
    • Biomedical Engineering
    • BlackBerry
    • Blogs
    • Bodybuilder
    • Bodybuilder Diet
    • Bodybuilder's Diet
    • Books
    • brain
    • Brain Cancer
    • brain structure
    • Brain Tumor
    • Brain wired for learning
    • Breakfast Diet
    • Bucknell Engineering Week
    • Bucknell Engineering Week-2013
    • Burning Fat
    • Camera
    • Cancer
    • caner treatment
    • Cars
    • central nervous system
    • common diseases
    • Computer
    • Cricket News
    • CSK News
    • Dengue Virus
    • Dengue Virus Infection
    • Devices
    • Diabetes
    • Diabetes overview
    • Diabetes patients
    • Diet
    • Diet for Bodybuilder
    • DNA
    • DNA Replication
    • Energy
    • Essential Diet Tips
    • facebook
    • Facebook Timeline
    • Filter Blood
    • four fundamntal human tissue
    • Games
    • gift cards
    • ginger
    • Google
    • hacking
    • Health benifit
    • Healthy Breakfast
    • Healthy Breakfast Routine
    • Heart
    • Heart Failure
    • Heart Failure Video
    • Hiv
    • HIV replication
    • Host web site server
    • How to create a Google AdSense account
    • How to Earn Money on YouTube
    • How To Earn Money Online From PTC Sites ?
    • How to Get Visitors (Traffic) to Your Blog from Go...
    • How to Insert Heading Tags to Blogger Blog Posts
    • How To Make Money From Facebook?
    • How to Make Money From Google : Proven Strategy
    • How To Make Money Online on YouTube
    • How To Make Money Online With Google AdSense?
    • How to Use Post Title As Title Tag in Blogger Blog
    • human body
    • Human nervous system
    • human tissue
    • If you already have a Google AdSense account
    • iMotion
    • Indian News
    • Information
    • INTERNET
    • iPad
    • IPL News
    • Jobs
    • Kidney
    • Laptop
    • Laptops
    • LG
    • LG Nexus
    • Make money
    • Make Money Online in India : An Adsense Gameplan
    • Make Money Online in India The Hard Way
    • Make Money Online Strategy in 2013 & Beyond
    • Make more money with Google Adsense – Simple trick...
    • Making Money Online From Home Possible?
    • medical debate
    • medical science
    • Medical video
    • medicalvideo
    • medicinevideo
    • Memory Card
    • Micromax
    • Microsoft Office Access 2007
    • Microsoft Office Excel 2007
    • Microsoft Office InfoPath 2007
    • Microsoft Office Outlook 2007
    • Microsoft Office Power Point 2007
    • Microsoft Office Word 2007
    • Mobile
    • Model Diet
    • Model's Diet
    • Model's Essential Diet Tips
    • Modern Medicine
    • Muscle building Secrets
    • Nephron
    • nerve
    • nervous system
    • Nexus
    • Online Data Entry jobs in India & The Hard Reality
    • Player Diet
    • Player's Diet
    • Ptc
    • Reabsorb water
    • Reviews
    • Samsung's
    • Secret Nutrition Tips for Player
    • Security
    • Self-test
    • SEO Tips For Blogger Blogspot Blogs
    • Smartphones
    • Software
    • Solar Energy
    • Sports Nutration
    • Super Food
    • Symptoms of Brain Tumor
    • Tablet
    • Tablets
    • Technology
    • thyroid
    • thyroid diseases
    • Thyroid Test
    • Tips And Trick
    • Tools
    • Traditional Medicine
    • Traditional vs Modern Medicine
    • treatment
    • Tutorials
    • USB
    • Vehicle
    • vlc
    • Ways of cancer treatment
    • Web Development
    • webdesign
    • What is cancer
    • What it Takes to Earn Money Online in India
    • Wi-Fi
    • Wi-Fi Devices
    • Wi-Fi Printer
    • windows
    • windows 98
    • Windows Phone
    • Windows Vista
    • windows XP
    • ZTE

    Blog Archive

Bloggerized by FiyaGalito & | Powered By Movizac.com