Sorted by:  

How to Repeat Row and Column Headings When You Print in Excel 2007

Excel 2007’s Print Titles command enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related [more…]

How to Use Excel 2007’s Scale to Fit Printing Options

Use the Scale to Fit settings in Excel 2007 if you need to make a worksheet fit to get a few last rows or columns on a single page. You can use the Width, Height, and Scale options in the Scale to Fit [more…]

Adjusting Page Breaks in Excel 2007

The Page Break Preview feature in Excel 2007 enables you to spot page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you [more…]

How to Print Formulas in an Excel 2007 Worksheet

A basic printing technique you may need in Excel 2007 is how to print the worksheet formulas instead of printing the calculated results of the formulas. You can check over a printout of the formulas in [more…]

Adding a Standard Header or Footer in Excel 2007

Headers and footers typically appear on every page of a report. In Excel 2007, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to [more…]

Printing Gridlines and Row and Column Headings in Excel 2007

In Excel 2007, you can print gridlines or row numbers and column letters on the page. Selecting these options results in a printout that closely resembles what you see on-screen. This feature is useful [more…]

Printing an Excel 2007 Chart

Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]

How to Create a Custom Header or Footer in Excel 2007

Although Excel 2007 provides standard header and footer text that you can select from drop-down menus, you also can create a custom header or footer. In addition to typical header or footer items such [more…]

Changing the Paper Orientation and Size in Excel 2007

In Excel 2007, you select the portrait or landscape page orientation, which affects the layout of the printed page. You also can adjust the Size setting based on the size of the paper you plan to print [more…]

Printing Particular Parts of an Excel 2007 Workbook

Within Excel 2007’s Print dialog box are the Print Range and Print What sections (in which you can select how much of the information is printed), and the Copies section, in which you can change the number [more…]

Telling Excel 2007 What You Want to Print

Excel 2007 includes a special printing feature called the print area. You can define any cell selection on a worksheet as the print area. After you define the print area, Excel then prints this cell selection [more…]

Printing a Worksheet in Excel 2007

If you can use the default print settings to print all the cells in the current worksheet, printing in Excel 2007 is a breeze. Simply add the Quick Print button to the Quick Access toolbar [more…]

Selecting a Printer in Excel 2007

Windows Vista and XP allow you to install more than one printer for use with applications such as Excel 2007. If you’ve installed multiple printers, the first one installed becomes the default printer, [more…]

Sign Up for RSS Feeds

Computers & Software