Thursday, October 2, 2014

10 Keyboard Shortcuts for MS Excel

1. Want to move to the beginning or end of a worksheet? Press Ctrl + Home or Ctrl + End rather than scrolling for what feels like forever.

2. Need to find or replace a specific piece of data? Press Ctrl + F to display the Find and Replace dialog box with Find selected… [Click here to read more]

3. Want to select a broad swath of data? Press Shift + Space to select the entire row, Ctrl + Space to select the entire column... [Click here to read more]

4. Want to copy, paste, or cut, or undo? Press Ctrl + C to copy the contents of selected cells... [Click here to read more]

5. Need to edit active or selected cells? Press Ctrl + D to fill complete cell down, Ctrl + R to fill complete cell to the right... [Click here to read more]

6. Want to insert a table, row, column, comment, or chart? Press Ctrl + l to insert a table, Ctrl + Shift + + to insert a cell, row, or column… [Click here to read more]

7. Need to set up or activate hyperlinks? Press Ctrl + K to insert a hyperlink and Enter in a cell with a link to activate it.

8. Want to hide or show elements? Press Ctrl + 9 to hide selected rows, Ctrl + Shift + 9 to unhide any hidden rows... [Click here to read more]

9. Need to format data? Press Ctrl + 1 to open the Format Cells dialog, Ctrl + B to apply or remove bold formatting... [Click here to read more]

10. Need to format numbers? Press Ctrl + Shift + $ to apply Currency format, Ctrl + Shift + ~ to apply General number format… [Click here to read more]

Email from Lawrence Schweitzer 

No comments:

Post a Comment