Leading the way in Microsoft Office Development

Excluding certain Rows and Columns

Any hidden rows or columns will not be printed. If you are printing with row and column headings any hidden rows or columns will be visible.

If you want to print your worksheet but to exclude certain rows or columns you can use the Group and Outline feature. This allows you to easily display your data and then hide it again before printing. Any rows or columns in an Outline that are grouped together will not be printed.

Printing multiple Areas

It is possible to set up multiple print areas on the same worksheet by using Custom Views and Print Report commands. Once you have defined a number of different views you can then define reports based on the views of your choices.

Printing several workbooks

You can select the workbooks in Windows Explorer, right click and select Print.

Excel will be opened automatically (if not open already) the workbooks will be printed and Excel will be closed afterwards.

Using Print Preview to Print

If you hold down the Shift key and press the Print Preview button on the Standard toolbar you will actually perform the same operation as clicking the Print button on the standard toolbar.

Printing Quickly

If you want to print your worksheets quickly and you are just checking the data is correct then it will be sufficient to print in draft quality. This will significantly speed up the time to print a worksheet. This can be changed from (File > Page SetUp)(Sheet tab, Draft Quality).

Saving your Settings

Open a new workbook

Change all the options, page setup etc

Save your workbook in the following directory so it will always be the default used when you create a new workbook.