• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing a Worksheet with Excel > Customizing Worksheet Printing

Customizing Worksheet Printing

At some point you'll want to print your worksheet so you can distribute it to others or use it for other purposes. You can print all or part of any worksheet, and you can control the appearance of many features, such as whether gridlines are displayed, whether column letters and row numbers are displayed, or whether to include print titles, columns and rows that are repeated on each page. If you have already set a print area, it will appear in the Print Area box on the Sheet tab of the Page Setup dialog box. You don't need to re-select it.

Print Part of a Worksheet

Click the File menu, and then click Page Setup.

Click the Sheet tab.

Click in the Print Area box, and then type the range you want to print. Or click the Collapse Dialog button, select the cells you want to print, and then click the Expand Dialog button to restore the dialog box.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint