IF you are likely to print the same range of cells over and over again, you can save your time and effort by setting up printing areas covering these cells. Unlike MS Excel 2003, you can set multiple print areas on the same worksheet. To define print areas, carry out the following steps:
~ Open the spreadsheet that needs to be printed.
~ Select the range to be printed.
~ Go to the 'Page Layout' tab.
~ Click the 'Print Area' button appearing under the 'Page Setup' group of the tab.
~ Click the 'Set Print Area' option from the drop down list.
~ To set another print area, select the next range to be printed.
~ Click the 'Print Area' button appearing under the 'Page Setup' group of the 'Page Setup' tab.
~ Click the 'Add to Print Area' option from the drop down list and proceed with printing the file.
If you need to access this option quite frequently, you can add the print areas option to the 'Quick Access Toolbar'. To do so, carry out the following steps:
~ Click the 'Office button' and click the 'Excel Options' button.
~ Click 'Customize' at the option from the left side panel of the 'Excel Options' dialog box.
~ Select the 'All Commands' option from the 'Choose Commands From' drop-down list.
~ Scroll and select the 'Set Print Area' command from the listed commands.
~ Click the 'Add' button to list the command in the tool bar.
~ Click on 'OK' to proceed.