Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Mouse Shortcut (All)

    I found out about this shortcut from the Excel tips newsletter

    This mouse shortcut can be used to navigate around your worksheet. When you select a cell, Excel places a bold outline around that cell. If you double-click on one of the borders of the cell, Excel moves the cell selection in the direction indicated by the border you double-clicked. No data is moved, it is a way to quickly move to another part of the worksheet.

    If you are in the middle of a data table then the cell selection will move to the edge of the data table. For example, double-click on the bottom border and it moves the cell selection to the bottom of the table. If you are in an empty cell, double-clicking on the border will change the selected cell to the first cell adjacent to a cell with data in it, again in the direction indicated by the border of the cell. If there is no data in cells to the right or below the selected cell then the selected cell will not change.

    When the selected cell is inside a data table, this mouse shortcut works in a similar way to using "Control + Directional arrow" on the keyboard, but behaves differently when in an empty cell.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Mouse Shortcut (All)

    Thanks, that's a useful tip.

    It has been around since Excel 97, or perhaps even earlier, but it is little known. It can be combined with Shift to extend the selection instead of moving it.

Posting Permissions

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