Printing in Excel 2010

Sorted by:  

How to Print an Excel 2010 Chart

Printing a chart in Excel 2010 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…]

Working in Excel 2010's Page Layout View

Excel 2010's Page Layout view gives you an instant view of how printed Excel pages will look. You activate this view by clicking either the Page Layout View button [more…]

How to Change the Paper Orientation and Size in Excel 2010

In Excel 2010, you select portrait or landscapepage 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 use to print [more…]

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

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

How to Use Excel 2010's Scale to Fit Printing Options

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

Adjusting Page Breaks in Excel 2010

The Page Break Preview feature in Excel 2010 helps you spot and fix page break problems in an instant, such as when the program wants to split onto different pages information that you know should always [more…]

Adding a Standard Header or Footer in Excel 2010

Headers and footers typically appear on every page of a report. In Excel 2010, 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…]

How to Create a Custom Header or Footer in Excel 2010

Although Excel 2010 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…]

How to Print Formulas in an Excel 2010 Worksheet

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

How to Print Gridlines and Row and Column Headings in Excel 2010

In Excel 2010, you can print gridlines or row numbers and column letters on the page. Printing gridlines and row and column headings results in a printout that closely resembles what you see on-screen. [more…]

Previewing Pages in Excel 2010's Backstage View

The Print panel of Excel 2010's new Backstage view enables you to see how your worksheet data will be paged when printed. Save wasted paper and your sanity by previewing your data before you print any [more…]

How to Select a Printer in Excel 2010

Windows allows you to install more than one printer for use with Microsoft applications. If you've installed multiple printers, the first one installed becomes the default printer, which is used by all [more…]

How to Print a Worksheet in Excel 2010

Excel 2010 offers a couple ways to send your Excel data to the printer. The Quick Print button often is all you need — it just sends the current page to the printer to create a single copy. But if your [more…]

How to Print Particular Parts of an Excel 2010 Workbook

The Print panel in Excel 2010's Backstage view includes commands that allow you to specify which parts of a workbook you want to print. You also can specify a print area from the Page Layout tab of the [more…]

How to Change the Print Margins in Excel 2010

Print margins indicate how much white space Excel 2010 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook have top and bottom margins [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software