Wednesday, December 25, 2013

How to Print or Page Setup in Excel 2007


1. Click the Office Button at the top left-hand corner. Select 'Print' from the options available and then select 'Print Preview.' In the Print Preview view you will see how the printed copy will look, as well as view and adjust the margins and view page setup options.
2. Select 'Page Setup.' In the dialog box that appears you can set the spreadsheet to print in Landscape mode instead of Portrait. Click the 'Margins' tab to adjust the margins of your spreadsheet as well as vertical and horizontal alignment.
3. Click the 'Header/Footer' tab. Enter any information you want to appear in the header or footer. Click on the drop-down menus below to insert special fields, such as 'Page x of y.'
4. Click on the rightmost tab, labeled 'Sheet.' You can select whether to print gridlines and/or row and column headings here. Click 'OK' after making changes to the page setup.
5. Click the Office Button at the top left-hand corner, then click 'Print,' and 'Print' again. There are several Print options you can choose from.
6. Choose the printer you want to print to by clicking the arrow beside the printer name to view a drop-down list of printer options. Select the printer you want to use.
7. Select the number of copies you want to print. You can also choose whether to print all of your workbook or just part of it under 'Print what.' Define which pages you want to print under 'Print range.' For example, you can choose to print pages 2 to 7 by entering '2-7'. After you make any necessary changes to print options, click 'OK' and your workbook will begin printing.

Blogger news