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
Open your document in Microsoft Excel. Click on a cell within the table to activate it.
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."
Click "Table" under the "Print What" option that will appear. Clicking "Table" will print the entire chart.
Print Part of a Worksheet
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.
Navigate your cursor to the "Page Setup" group located inside the new "Page Layout" tab at the top of the worksheet. Click "Print Area."
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.