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]
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