Works: Highlight Disappears when Tabbing Between Cells (112404)


The information in this article applies to:

  • Microsoft Works 2.0a
  • Microsoft Works 3.0
This article was previously published under Q112404

SUMMARY

You can highlight an area of a spreadsheet, then use the TAB key to move from cell to cell within the highlighted area. The active cursor progresses from left to right as you press the TAB key. When you reach the rightmost cell in the highlighted area, pressing TAB moves you to the first cell on the next row in the selection. When you reach the last cell in the highlighted area, the active cursor returns to the first cell, and the selection remains highlighted.

However, if some of the cells in the selected area are locked and protected, the cursor and selection behave differently. In this case, when you press TAB to move through the selection, the active cursor skips over the locked and protected cells. Additionally, if part of the locked and protected cells are outside of the highlighted selection, the active cursor does not return to the first cell. Instead, the cursor moves down to the next row and the highlight disappears.

MORE INFORMATION

Steps to Reproduce Problem

  1. Create a new spreadsheet.
  2. Enter numbers in cells A1 through E3.
  3. Unlock and unprotect the spreadsheet.
  4. Highlight cells B1 through B3.
  5. Lock, then protect the cells.
  6. Highlight cells A1 through E3 and press TAB to move through them. The highlight skips over column B, but the highlight remains so you can continue to move through the selection over and over.
  7. Highlight cells A1 through E2. Now part of the locked and protected area resides outside of the selection. Press TAB to move through the selection. When you get to cell E2, the highlight disappears if you press the TAB key again and the active cursor is now on the row below.
Modification Type:MajorLast Reviewed:10/6/2003
Keywords:kbhowto KB112404
©2003 Microsoft Corporation. All rights reserved.