Friday, April 12, 2013

Keyboard shortcuts

Sharing some keyboard shortcuts: 
  1. Arrow Keys: Move one cell up, down, left, or right in a worksheet.
  2. Page Down/Page Up: Move one screen down / one screen up in a worksheet.
  3. Alt+Page Down/Alt+Page Up: Move one screen to the right / to the left in a worksheet.
  4. Tab/Shift+Tab: Move one cell to the right / to the left in a worksheet.
  5. Ctrl+Arrow Keys: Move to the edge of next data region (cells that contains data)
  6. Home Move to the beginning of a row in a worksheet.
  7. Ctrl+Home: Move to the beginning of a worksheet.
  8. Ctrl+End: Move to the last cell with content on a worksheet.
  9. Ctrl+f: Display the Find and Replace dialog box (with Find selected).
  10. Ctrl+h: Display the Find and Replace dialog box (with Replace selected).
  11. Shift+F4: Repeat last find.
  12. Ctrl+g (or f5): Display the 'Go To' dialog box.
  13. Ctrl+Arrow Left/Ctrl+Arrow Right: Inside a cell: Move one word to the left / to the right.
  14. Home/End: Inside a cell: Move to the beginning / to the end of a cell entry.
  15. Alt+Arrow Down: Display the AutoComplete list e.g. in cell with dropdowns or autofilter.
  16. End: Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right.
More to come ..... 

2 comments: