Topic: Print Area

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adding the Set Print Area Tool Need to set print areas quite often? Adding a tool that allows you to quickly make the specification can be a great time saver. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Centering Your Worksheet When it comes time to print out your worksheet, it helps to position the worksheet on the printed page in an appealing manner. One way to do that is to center the information either horizontally or vertically on the page. This tip shows how easy it is to do this type of formatting. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Clearing the Print Area If you want to print only a given portion of a worksheet, Excel allows you to set up a print area. This is a named range that is used by the printing routines in Excel to limit what is printed. This tip explains how to get rid of any print areas you may have previously created. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Multiple Print Areas on a Single Printed Page You can select non-contiguous ranges of cells and set them as the print area for a worksheet. Getting those ranges on a single sheet of printout, however, is a different story; Excel wants to put each range on its own page. This tip explains some of the ways you can work around this behavior of Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Printing a Chart Across Multiple Pages Wouldn’t it be great to have your huge charts print out on multiple pieces of paper that you could then piece together? While Excel doesn’t provide this capability directly, this tip looks at some ways that you can get the multi-page printout you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Printing a Single Column in Multiple Columns The data in some worksheets consists of just a column or two of data, extending for many rows. When you print these worksheets, you end up with a printout that has a lot of white space on the right side of the page. You could use less paper if you were able to “snake” your column on the page so that it occupied multiple columns. This tip shows you how. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Printing Columns and Rows When you print something from Excel, you normally print an entire worksheet, a page, or a selected range of cells. If you want to print a row and a column (and nothing else), then you will need to prepare the worksheet for printing first. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Printing Just the Visible Data How to print data that is visible on the screen versus an entire workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Printing Multiple Selections If you have multiple selections of a worksheet that need to be printed (and parts that don’t), then you will enjoy this tip. It explains how to create a “consolidation sheet” that contains just the information that you want printed. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Printing Multiple Worksheet Ranges Naming ranges of cells is a common task when developing a worksheet. If you want to print those cell ranges, you can do so by applying the information in this tip—just specify your ranges and then print away! Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting Header/Footer Margins The default margins for your headers and footers is .75 inches, left and right. Unfortunately there is no way to change this margin; it is hard-coded into the program. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting Page Margins An easy tip on how to set the page margins of your Excel workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting the Print Area When you print a worksheet, normally Excel prints everything on the worksheet. If you want to limit what is actually printed, you can set a print area that encompasses the cells you want on the printout. This tip explains two ways you can easily define a print area. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds