Carol's Corner Office

Have you ever wondered how to print specific pages of your worksheet like you can do in MS Word? Well if you have, read on.

If each of your worksheets fit on one page (single sheet) then the answer to your question is fairly simple.  All you really need to do is select the worksheets that you would like to print, using your CTRL key to select each worksheet tab. Then when you print, only those worksheets will be printed.

However, if you would like to print specific pages from a worksheet that normally flows to multiple pages, then the answer is a bit more vexing.

One method is to temporarily hide the unwanted portions of your worksheet and then print the unhidden area. There is, however,  a much simpler resolution.

Follow the steps below to learn how:

1. Click on View | Page Break Preview.
2. MS Excel will display your worksheet, showing the various page breaks. In version 2007, this view is available to you by displaying the View tab of your Ribbon and clicking the Page Break Preview tool in the Workbook Views group.
3. Select all cells in the first page you want printed.
4. Hold down your CTRL key and select all the cells in your second page you want printed.
5. Repeat steps 3 and 4 above,  for each page you would like to print.
6. Click on File | Print to display the Print dialog box.  In version 2007, click Office button | Print.
7. In the Print What area, select Selection.
8. Click OK.
9. MS Excel will print the pages you previously selected.
10. Close the Page Break Preview display.

Versions 97, 2000, 2002, 2003, 2007