Wednesday, January 9, 2008

Tip#3 **Hot Tip**

Here are some basic short-cuts to move in a perticular sheet

  • Cursors - To move to a cell towards the left, right, up or down.
  • Enter - To accept the text, the number or the formula that was entered in the cell.
  • Tab - Moves the cursor a cell to the cell on the right of the active cell.
  • Shift + Tab - Moves the cursor a cell to the left of the active cell.
  • End + cursor OrCtrl + cursor - To move at the end of a series of filled cells, with some content, or a series of empty cells.
  • PageUp and PageDn - To move a screen up or down.
  • Alt + PageUp and Alt + PageDn - To move of one screen to the left or to the right.
  • Ctrl + PageUp and Ctrl + PageDn - To move to the previous or following worksheet.
  • Ctrl + Home - To return to the upper left corner of the current worksheet.
  • Ctrl + End - To move in the last cell containing text, a number or a formula.
  • F5 or Ctrl + T - To move directly to any cell of the file.

No comments: