Force Byte
Printing Worksheets in Excel (5)

1 Photo

In this issue, I will focus on the details of the "Sheet" tab and the relevant functions.

Setting the 'Sheet' tab

Click the "Sheet" tab once to display the following "Page Setup" dialogue box (See Figure 1).

Figure 1

The function of each field in the above dialogue box is described below:

Print area

You may specify the area to be printed in this field directly. If there is more than one print area, you may use commas to separate them. For example, to print cells A2 to C3 and E5 to F6, you can enter "A2:C3, E5:F6".

Print titles

The title described here is different from the Header/Footer mentioned last time. It refers to the row label and the column label of the worksheet. Besides, it consists of the following two options for you to configure:

* Rows to repeat at top

You may specify a row area as the "Rows to repeat at top" here. After that, the "Rows to repeat at top" will be printed on the top of each page before the content of the worksheet. This is suitable for the printing of a very long worksheet. Since the whole content of the worksheet cannot be printed in one page, it may be difficult to understand the content and the meaning of each column when you read the second page if it does not contain any column labels as reference.

Let's see the following worksheet:

A1
 
C1
 
2002 2003
a Robbery With Firearms
3
-
b Robbery With Arms (Stun Guns)
2
3
c Robbery With Pistol-like Object
48
37
d Bank Robbery
33
32
e Goldsmith/Watch Shop Robberies
5
7

Suppose the worksheet is too long to be printed in one page, you may specify cells A1 to C1 as the "Rows to repeat at top" and the "column labels" shown below will be repeated on the top of each page.

                     
2002 2003

Then the actual content of the worksheet will be printed after the "column labels".

* Columns to repeat at left

You may specify a column area as the "Columns to repeat at left" here. Similarly, the "Columns to repeat at left" will be printed on the left of each page before the content of the worksheet. This is suitable for the printing of a very wide worksheet because the row labels are then given on every page printed and you may find it easier to understand the content and the meaning of each row.

We assume that there is another worksheet with the following content:

A1
 
 
 
 
A6
  2002   200X
a Robbery With Firearms
3
..
-
b Robbery With Arms (Stun Guns)
2
..
3
c Robbery With Pistol Like Object
48
..
37
d Bank Robbery
33
..
32
e Goldsmith/Watch Shop Robberies
5
..
7

Again it is too wide to be printed in one page, you may specify cells A1 to A6 as the "Columns to repeat at left" so that these "row labels" will be printed on the left side of each page.

a Robbery With Firearms
b Robbery With Arms (Stun Guns)
c Robbery With Pistol-like Object
d Bank Robbery
e Goldsmith/Watch Shop Robberies

Similarly, the actual content of the worksheet will then be printed beside the "row labels".

Let's stop here and I will continue with the other fields on the "Sheet" tab in the next issue.

"Sharing IT as it applies to your daily life."

(E-mail address: ITB_ForceByte_Editor@police.gov.hk)


<<Back to Features>> <<Back to Top>>