Printing Parts of a File - Excel 2003/2007

If you have to print specific parts of a file over and over again, it can be quite time consuming, especially if you have to keep selecting the area before firing a print command. If you have a single such printable area, you can set it as a 'Print Area'. If you have multiple print ranges you can store each of them as custom views. Here's how,

• Select the range and set its print preferences.
• Go to the 'View | Custom Views…'menu command.
• Click the 'Add' button on the 'Custom Views' dialog box.
• Enter a view name for future use.
• Check the 'Print Settings' option appearing under the 'Include in view' section of the dialog box.
• Click 'OK' to save the changes.To view the saved views,
• Go to 'View | Custom Views…'.
• Select the required view name and click the 'Show' button on the 'Custom Views' dialog box.

To create views in MS Excel 2007 follow these steps:

• Select the range  and set its print preferences.
• Go to the 'View' tab and click the 'Custom Views' option under 'Workbook Views'.
• Click the 'Add' button on the 'Custom Views' dialog box.
• Enter a view name for future use.
• Check the 'Print Settings' option appearing under the 'Include in view' section of the dialog box.
• Click 'OK' to save the changes. To view the saved views,
• Go to the 'View' tab and click the 'Custom Views' option appearing under the 'Workbook Views' section.
• Select the required view name and click the 'Show' button on the 'Custom Views' dialog box.

You can add as many views as you wish to. You just need to make sure that the name of the view is relevant. To print, just display the view and fire the print

Category: Office, Tips