Microsoft KB Archive/34849

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:21, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q34849 to Microsoft KB Archive/34849 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Excel 2.x: Freeze Panes with Sized Window Freezes Wrong Row PSS ID Number: Q34849 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:

The following is an example of a problem with the Freeze Panes command:

  1. Split a worksheet between rows 5 and 6.
  2. Size the window so that only part of row 1 is visible.
  3. From the Options menu, choose Freeze Panes.

Excel will freeze a split between rows 1 and 2, not between rows 5 and 6.

More Information:

This is a result of resizing the window. The split indicator on the scroll bar is moved in conjunction with the resizing. Its new position is where the split will occur.

Microsoft has confirmed this to be a problem in Excel versions 2.0, 2.01, and 2.1 for Windows and Excel versions 2.2 and 2.21 for OS/2. This problem was corrected in Excel 3.0.

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.