<<Convert Excel Spreadsheets to Web Pages | Trading Software That Operates Within Excel | Convert Excel, Access & Other Databases | Merge Excel Files>>
Ozgrid, Experts in Microsoft Excel Spreadsheets

Excel Printing 3

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

Tricks for Getting the Most out of your Printing

Excel Printing Tricks......  Excel Printing Page 2

As you are no doubt aware, the more time you spend on your Excel Spreadsheet Design the easier your worksheet will be to use and manipulate.  You must also be aware of the people who want to read the information you are presenting to them.  Here are a few tricks that will make your printing easier to read and understand.

NOTE:  Many people turn their Gridlines off when they are formatting a worksheet.  This enables you to see exactly what your work will look like when you print it.  If you wish to do this go to Tools>Options and check the Gridlines option under Window options.

VISUALLY

HOW TO SQUEEZE THAT BIT MORE ON YOUR PAGE

There are a couple of things that you can do try to squeeze a bit more on your page.  Try these:

PRINTING TO MULTIPLE PAGES

If you have a lot of data, sometimes it may be better to spread the information over two pages, rather than squash it all on to one page so that it is very small and hard to read, you can easily print to multiple pages in Excel. 

If you want your column headings, or your row headings or both repeated on any subsequent pages, Try this:

  1. Go to File>Page Setup>Sheet. (if you try accessing the Page Setup dialog via Print Preview the relevant options are greyed out). 
  2. The top option Print Area allows you to select the range that you wish to print if you have not already done so.
  3. Under Print Titles there are two options, Rows to Repeat at Top and Columns to Repeat at Left.  Click the collapse tool (the red arrow) and collapse through and select either the Row number (Rows to Repeat at Top) you wish to repeat on each subsequent page, or the column letter (Columns to Repeat at Left) you wish to repeat on each subsequent page. 
  4. Press your collapse box button again to expand the box.

Click here to go to Excel Printing 1

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALLpurchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.


Instant Download and Money Back Guarantee on Most Software

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates