![]() To lower right hand corner of the area containing data To last row containing data in that column or to Row 65536 To first row containing data in that column or to Row 1 To first column containing data in that row or to Column A To last column containing data in that row or to Column AMJ Moving from cell to cell using the keyboard Key Combination Holding down Alt+Cursor key resizes a cell. Table 1 describes the keyboard shortcuts for moving about a spreadsheet. Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways.Page Down moves the display down one complete screen and Page Up moves the display up one complete screen.End moves the focus to the column furthest to the right that contains data.Home moves the focus to the start of a row.Pressing the arrow keys on the keyboard moves the focus in the direction of the arrows. Pressing Tab or Shift+Tab moves the focus right or left, respectively.Pressing Enter or Shift+Enter moves the focus down or up, respectively.This method is most useful when the two cells are a large distance apart. To move the focus using the mouse, simply move the mouse pointer to the cell where the focus should be and click the left mouse button. (Left) One selected cell and (right) a group of selected cells Using the mouse In the figure below, the Navigator would select cell G28. Type the cell reference into the top two fields, labeled Column and Row, and press Enter. Or just click into the Name box, delete the existing cell reference, and type in the cell reference you want.Ĭlick on the Navigator button in the Standard toolbar (or press F5) to display the Navigator. Type the cell reference of the cell you want to go to and press Enter. The existing cell reference will be highlighted. Place the mouse pointer over the cell and click.Ĭlick on the little inverted black triangle just to the right of the Name Box on the Formula Bar. Going to a particular cell Using the mouse ![]() 2.5 Customizing the effect of the Enter key.2.4 Using Home, End, Page Up and Page Down. ![]()
0 Comments
Leave a Reply. |