Results 1 to 8 of 8
  1. #1
    Bill Fuhrmann
    Guest

    selection of blocks of cells (97 SR-2)

    This is likely to be obvious or nonexistant. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Can the anchored corner of a block of cells be changed while they are being selected?
    In 1-2-3, you could press the period key (if I remember right) while expanding a selection block and the anchored corner would rotate around the corners of the block.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: selection of blocks of cells (97 SR-2)

    Ctrl-Period.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Bill Fuhrmann
    Guest

    Re: selection of blocks of cells (97 SR-2)

    Thank you. That is exactly what I was looking for.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: selection of blocks of cells (97 SR-2)

    BTW, I just noticed something a bit counterintuitive about this capabilty. If you want to extend the range by altering the active cell using Ctrl-Period, you have to activate (reverse highlight) the cell at the OTHER end or side of the direction in which you want to extend; think of the highlighted cell as the anchor cell. Been a long time, but l think it was the other way around in Lotus - the highlighted cell was the point from which you would extend. And don't forget to take your finger off the Ctrl key and move it to the Shift Key.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: selection of blocks of cells (97 SR-2)

    The tab key also cycles you through the selected cells while keeping them selected. If that helps at all...

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: selection of blocks of cells (97 SR-2)

    Correct, it cycles through ALL cells in the selection, as opposed to the corner cells.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Bill Fuhrmann
    Guest

    Re: selection of blocks of cells (97 SR-2)

    I get to blame my inability to find the "control period" combo to that that bit of counterintuitiveness and to the poor help system.

    Of course, I was trying various combinations of keys with the period (including control) while holding the shift key to extend the block. "control greater than" doesn't shift the corner.

    Leaving the highlighted cell in the anchor corner is consistent with the way blocks of cells are marked in Excel but if you have part of the range off the screen, it can leave you wondering when it is in the far corner from the one you want to move.

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: selection of blocks of cells (97 SR-2)

    Exactly. So if your selection extends beyond the current window, you have to select the "anchor" side with Ctrl-Period, then slide the scroll bar to show the "unanchored" edge you want to extend, then Shift-Arrow the selection to where you want to extend. Not an efficient keyboard operation.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •