Configuring Sheet Printing

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Configuring Sheet Printing

Introduction

You have probably realized that some of the documents we print don’t include a worksheet’s header columns, header rows, or gridlines. This is because in most cases they can be ignored. In some circumstances, such as when performing some presentations or illustrations, you may want to print some or everything that is part of the worksheet. That’s what you can configure from the Sheetproperty page of the Page Setup dialog box. To access it:

  • In the Sheet Options section of the Page Layout tab of the Ribbon, you can click the More Options button to show a list of the available options and click the desired one

Sheet

  • Display the Page Setup dialog box and click Sheet:

Sheet

The Print Area

The Print Area text box allows you to delimit a section of your worksheet for printing. To use it, click its selection button  . This would shrink the Page Setup dialog, allowing you to make a selection of the area you want to print. After setting the desired area, you can click the selection button  to restore the Page Setup dialog box.

Print-Repeating Some Rows

Most of the time, when creating a list of items, you would set the list headers only on top of the worksheet. As you continue entering the items, the list grows. If you decide to print such a long list that spreads on various pages, after the 1st page, the subsequent pages would not display their headers. This could be confusing in some circumstances.

The Sheet property page allows you to set or select a row or range of rows that would display on top of every printed sheet. If you know the row or range of rows you want to use, you can just type it in the Rows To Repeat At Top text box, but the safest way to configure it is to click the selection button  , then click any cell in the desired row or click the desired cells. In either case, the whole row or the rows will be selected.

Print-Repeating Some Columns

The Columns To Repeat At Left text box is used like the previous box except that, this time, it would display a particular column on the left side of each printed sheet.

Printing the Gridlines

If you want to print the gridlines, in the Print section, click the Gridlines check box

Printing the Column Headers and Row Headers

If you want to display the column and row headers on your printed paper, click the Row And Column Headings check box.

Practical LearningPractical Learning: What to Print From The Sheet

  1. Access the Grier Summer Camp2 workbook and click the Registration tab
  2. On the Ribbon, click Page Layout if necessary.
    In the Sheet Options section, click the more options button
    Sheet
  3. Make sure the Sheet property page is selected.
    On the right side of the Print Area text box, click the selection button Selection 
  4. On the worksheet, select cells C4:G28
  5. Click the stop selection button 
  6. Click the Print button
  7. From the Print dialog, click OK
  8. Access the DAWN Report1 workbook from the taskbar
  9. In the Page Layout tab of the Ribbon, in the Page Setup section, click the more options button More Options
  10. In the Page Setup dialog box, make sure the Page tab is selected. Click the Landscape radio button
  11. Click the Sheet property page to make it active
  12. If there is anything in the Print Area text box, delete it
    In the Print section, click the Gridlines check box
  13. Also click the Row and Column Headings check box
     
    Page Setup
  14. Click the Print Preview button
     
    DAWN Report
  15. In the Print Preview window, click the Print... button
  16. In the Print dialog box, click OK
  17. Access the Grier Summer Camp1 workbook from the taskbar
  18. On the Ribbon, click Page Layout if necessary. In the Sheet Options section, click the more options button and make sure the Sheet tab is active
  19. On the right side of the Rows To Repeat At Top text box, click the selection button 
  20. Click cell B4 (Regist Date)
  21. Click the stop selection button 
  22. Click the Print button.
  23. In the Print dialog, click OK
  24. Exit from Microsoft Excel. When closing the workbooks, anytime you are asked whether to save, click No