Microsoft KB Archive/29793

Setting Multiple Row and Column Print Titles in Excel PSS ID Number: Q29793 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

When setting multiple adjacent rows or columns for print titles, the error message “INVALID PRINT TITLE” appears when using the SHIFT+F8 key combination to select multiple adjacent columns and rows.

This problem was corrected in Microsoft Excel version 4.0.

More Information:

Using the SHIFT+F8 (Add) key combination to select multiple adjacent rows or columns causes the selected area to be defined as the row or column union. As a result, Excel does not recognize the rows or columns as adjacent when setting a Print Title.

Adjacent Rows
To select adjacent rows using the keyboard, do the following:


 * 1) Move the active cell to the first row to be contained in the Print Title.
 * 2) Press SHIFT+SPACEBAR to select the first row.
 * 3) Press the F8 key, and then press UP ARROW or DOWN ARROW to extend the selection.
 * 4) From the Options menu, choose Set Print Titles.

Adjacent Columns
To select adjacent columns using the keyboard, do the following:


 * 1) Move the active cell to the first column to be contained in the Title.
 * 2) Press CTRL+SPACEBAR to select the first column.
 * 3) Press the F8 key, followed by a LEFT ARROW or RIGHT ARROW directional key to extend the selection.
 * 4) From the Options menu, choose Set Print Titles.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.