Wednesday, June 13, 2012

How to Save Print Settings in Excel 2007


1. Open Microsoft Excel from the Windows Start Menu by clicking 'Start' > 'Program Files' > 'Microsoft Excel'. The application will start in a new window.
2. Open your spreadsheet from the top pull-down menu. Click 'File' and 'Open...', and then select your spreadsheet file using the file browser window.
3. Select the cells you want to print by clicking and dragging your mouse on the spreadsheet to highlight the cells of your choice.
4. Open your Page Setup settings from the top menu by clicking 'File' > 'Page Setup...'. Adjust the margins and page orientation to fit what you are printing through your custom view.
5. Click on 'View' > 'Custom Views' from the top menu to open a new dialog box which will allow you to add a new custom view for printing. Click on the 'Add...' button in the Custom Views dialog box.
6. Type in the name you want to use for your new custom view in the 'Name:' text field. Keep the 'Print Settings' and 'Hidden Rows, Columns and Filter Settings' options selected and click the 'OK' button to add your new print view.
7. Click on 'Views' > 'Custom Views' again to list the created custom views in your document. To load the view, click the 'Show' button. When you print your document, the print settings that were saved with your custom view will be used.

Blogger news