How to Print in Excel 2007

By Nicholas Briano

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 1

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

Step 2

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 3

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

Print Part of a Worksheet

Step 1

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 2

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 3

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

Tips & Warnings

  • If you make a mistake highlighting, just click on an empty space of the table to deactivate the highlighted portions.
  • To change the paper layout from portrait to landscape, press "Ctrl" and "P" to print. Click on "Properties" to change the paper layout.