How to Print in Excel 2007

Microsoft Excel is one program included in the Microsoft Office suite. While using Excel, many users waste a lot of paper printing needless portions of a table. In Excel 2007, users can print a whole table or portions of a table using the Page Layout function at the top of each worksheet. The new Microsoft Office button has compiled many of the common functions in earlier versions into a concise list of command options that are easily manageable.

Print Whole Worksheet

Step

Open your document in Microsoft Excel. Click on a cell within the table to activate it.

Step

Click the Microsoft Office button at the top of the worksheet. The Microsoft Office button will appear as a light blue circle with the Office logo inside. Click “Print” or use the keyboard shortcut "Ctrl" and "P," followed by “OK.”

Step

Click “Table” under the “Print What” option that will appear. Clicking “Table” will print the entire chart.

Print Part of a Worksheet

Step

Click on a cell and drag your mouse cursor to the rest of the table you wish to print. The table will highlight in a shaded color to indicate the highlighted cells.

Step

Navigate your cursor to the “Page Setup” group located inside the new “Page Layout” tab at the top of the worksheet. Click “Print Area.”

Step

Click “Set Print Area” to set the highlighted cells for printing. Print the worksheet by pressing "Ctrl" and "P," followed by “OK.”