Microsoft KB Archive/29760

Works: Rows Duplicate Automatically from Titles

PSS ID Number: Q29760 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

Problem:

Rows appear to duplicate when titles are frozen and a frozen title is selected. This problem can be duplicated in the spreadsheet by following these steps:


 * 1) Open a new spreadsheet.
 * 2) Type A1= Title 1 in cell A1, A2= Title 2 in cell A2, and A3= Title 3 in cell A3.
 * 3) Select row 4 by pressing CTRL+F8 with the cursor in row 4.
 * 4) Select the Options command for Freeze Titles.
 * 5) Select the cell A1 with your mouse or using the Search command.

Rows 1 through 3 will duplicate in rows 4 through 6, and the selection still will be in row 4.

Response:

Rows 1 through 3 will not duplicate in rows 4 through 6; they will appear twice, as frozen cells above and unfrozen cells below.

If you click on a cell in the frozen area, the cell will not be selected. It will scroll into view in the unfrozen area, where it can be subsequently selected by another mouse click. This is by program design.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.