This article describes two features which are very useful when printing worksheets in Microsoft Excel: Print Titles and Set Print Area.
Print Titles
In addition to printing headers and footers on every page, Excel also allows you to specify Print Titles. Whereas headers and footers give an overall description of the report, print titles are taken from the worksheet itself. They are normally row and column headings and they are very often an essential part of the printed report.
For example, let's say you have a worksheet with only five average-sized columns but several hundred rows, although the header and footer appear on every page, only page 1 will have column headings. This means that it becomes difficult to know what the figures on the other pages relate to. We can make use of Excel's Print Titles feature to print the column headings on every page. Print Titles are in the Page Setup section of the Page Layout tab; simply click on the button and Excel displays the Page Setup dialog box with the Sheet tab activated. In our five column worksheet example, we would only need to specify the number of rows that we want to repeat at the top of every page. In our example, it would be only the first row. Having clicked to specify row one, we can click Print Preview to see the result and we would see that the headings are repeated at the top of each page.
Only one print area can be specified at a time. The Clear Print Area command will restore normal behaviour; so that, when you print, the entire worksheet will be printed.
When you print a worksheet, Excel normally prints all the data that it contains. However, there are times when you only want to print a selection of your data. Although you can achieve this by hiding rows and columns, Excel offers a simpler solution.
In the Page Layout tab of the Excel ribbon, you will find the Set Print Area drop-down menu. When you click on it, it offers two options: Set Print Area and Clear Print Area. The Set Print Area command allows you to highlight a range of data and specify that this is the only part of the worksheet that will be printed whenever you use the print command. Having chosen the Set Print Area command, Excel displays a dotted lined border around the area that has been set, in much the same way as it normally displays the page boundaries after the print command has been used.
For example, let's say you have a worksheet with only five average-sized columns but several hundred rows, although the header and footer appear on every page, only page 1 will have column headings. This means that it becomes difficult to know what the figures on the other pages relate to. We can make use of Excel's Print Titles feature to print the column headings on every page. Print Titles are in the Page Setup section of the Page Layout tab; simply click on the button and Excel displays the Page Setup dialog box with the Sheet tab activated. In our five column worksheet example, we would only need to specify the number of rows that we want to repeat at the top of every page. In our example, it would be only the first row. Having clicked to specify row one, we can click Print Preview to see the result and we would see that the headings are repeated at the top of each page.
![]() DELL LAPTOP LATiTUDE D630 20GHZ 2GB WINDOWS 7 DVDRW DVD WiFi NOTEBOOK COMPUTER US $199.99
|
![]() Brand New 5 pcs Computer Laptop Intel CORE 2 DUO Label Logo Stickers O005 US $.11
|
![]() Traffic Lights Shape USB 20 3 Port Hub Laptop Computer US $7.04
|
![]() PC COMPUTER REPAIR COURSE TECHNICIAN TOOLS 6 CD DVD US $10.35
|
![]() AMD PHENOM II 555 32GHz CUSTOM COMPUTER SYSTEM NEW PC US $419.00
|
![]() PERFORMANCE CUSTOM BUILT DESKTOP Computer w Monitor and Printer US $405.00
|
![]() KINGSTON MEMORY LOT OF 2X 2GB DDR2 KTH XW8200 2G 4GB ECC SERVER COMPUTER RAM US $15.50
|
![]() 60X2P AWD DO IT ON ALL FOURS STICKER CUT OUT COMPUTER CAR TRUCK MOTOR BIKES US $1.50
|
![]() 60x2P ANCHOR DECALS STICKER CUT OUT WALL COMPUTER HELMET CAR MOTOR BIKES US $1.50
|
![]() 60x2P RHINO FLAME STICKER CUT OUT WALL COMPUTER TRUCK JDM CAR MOTOR BIKES US $1.50
|
![]() 60x1P 3 SKULL HEAD GLOVES STICKER CUT OUT WALL COMPUTER CAR MOTOR BIKES US $1.50
|
![]() 60X1P BLUE MARINE SEA FISH STICKER CUT OUT WALL COMPUTER CAR MOTOR BIKES US $1.50
|
![]() 45X2P JOKER CARD STICKER CUT OUT COMPUTER CAR TRUCK BUMPER ATV MOTOR BIKES US $1.50
|
![]() 45X2P COOL STORY BRO STICKER CUT OUT WALL COMPUTER CAR TRUCK MOTOR BIKES US $1.50
|
![]() 7 Google Android 22 Tablet PC Computer Netbook M009 US $69.95
|
![]() RARE AUTHENTIC BACKSTREET BOYS COMPUTER BAG FROM THE 2005 NEVER GONE TOUR US $29.99
|
![]() Wireless Computer Bluetooth Headset Hi Fi Headphone MSN US $24.88
|
![]() BUTTERFLY AND MUSHROOMS COMPUTER PC MOUSEPAD MOUSE PAD MAT NEW US $.98
|
![]() LEAP FROG CLICK START MY FIRST COMPUTER SET in Box and also with Boxed Game US $25.00
|
![]() Wireless Bluetooth Stereo Headset Headphone Mic for iPhone4S Cellphone Computer US $39.99
|
![]() 24G Wireless Optical Mouse Red For PC Laptop Notebook ComputerUSB Receiver US $.01
|
![]() Roland D50 D 50 Voices 10 BANKS Computer Load US $39.95
|
![]() INTEL i7 950 306GHz QUAD CORE DESKTOP COMPUTER SYSTEM US $819.00
|
![]() Canon 5565B001 X Mark I Mouse Slim Computer Link Calculator US $19.99
|
![]() 97 Avenger Eclipse Transmission Computer TCU P05293114AB US $50.00
|
![]() DELL LATiTUDE D630 Laptop 2GHZ 2GB WINDOWS XP 3 CDRW DVD WiFi NOTEBOOK COMPUTER US $199.99
|
![]() For Computer Vista USB 20 Dorable Dog Webcam Camera US $13.59
|
![]() 900 056 — ESD Antistatic Computer Field Service Kit US $27.79
|
![]() 99 1999 Jaguar Body Processor Module 98 99 00 01 02 03 Jag Body Computer US $9.99
|
![]() VINTAGE 80s TEXAS INSTRUMENT TI 99 4A CORE COMPUTER SYSTEM CONSOLE w BOX GAMES US $129.99
|
![]() Watch DIGITAL CABLE SATELLITE TV on Your Computer or Laptop PC for Free on CD US $6.99
|
![]() Watch DIGITAL CABLE SATELLITE TV on Your Computer for FREE No Box Needed US $6.99
|
![]() Adjustable Stereo Headset Headphone w Microphone for Computer US $7.74
|
![]() 27 Children Kids Computer Games PC Windows Mac Software Great Assortment US $19.99
|
![]() FAST DELL OPTIPLEX PC P4 20 GHZ CDRWDVD COMPUTER WINDOWS XP PRO FREE SHIPPING US $51.00
|
![]() PC Computer 5 Ports Type A B Composite USB Hub Switch US $20.66
|
![]() DataMate DM 7015 serial adapter RS232 to RS422 control a VTR from computer US $30.00
|
![]() RED USB 300M 6 LEDs LED WEBCAM CAMERA WEB CAM MIC FOR PC LAPTOP computer US $9.55
|
![]() NEW Mini wireless Mic Microphone for Computer PC laptop NOTEBOOK US $3.55
|
![]() silver USB 300M 6 LEDs LED WEBCAM CAMERA WEB CAM MIC FOR PC LAPTOP computer US $9.55
|

























































