Announcement:

This is a Testing Annocement. I don't have Much to Say. This is a Place for a Short Product Annocement

Save Your Marriage Now!

TECHNOLOGY

81 Microsoft Excel shortcut keys – Master your Spreadsheet



Mastering these Microsoft Excel shortcut keys, you will be amazed how fast you could get your job done with ease.

81 Microsoft Excel shortcut keys you should know.

Be that guru you have always wanted to be. With these shortcut keys, you will not only master excel, but you will good at using the keyboard.

  1. Ctrl+K > Insert Hyperlink.
  2. Ctrl+N > New Workbook.
  3. Ctrl+H > Replace.
  4. Ctrl+C > Copy.
  5. Ctrl+F > Find.
  6. F4 > While typing a formula, switch between absolute/ref.
  7. F5 >
  8. Edit, Goto.
  9. F6 > Next Pane None
  10. F7 > Spell check
  11. F8 > Extend mode
  12. F9 > Recalculate all workbooks Tools, Options, Calculation.
  13. F10 > Activate Menu bar.
  14. F11 > Insert  Chart
  15. F12 > Save File As
  16. Ctrl+: > Insert Current Time
  17. Ctrl+; > Insert Current Date
  18. Ctrl+” > Copy Value from Cell Above
  19. Edit, Paste Special, Value
  20. Ctrl+’ > Copy Formula from Cell Above Edit, Copy Shift
  21. Shift+F1 > Help
  22. Shift+F2
  23. Tab > Next tool
  24. Shift+Tab > Previous tool
  25. Shift+Ctrl+F > Font Drop Down List
  26. Shift+F3 > Insert Function into formula.
  27. Shift+F4 > Find Next

Read Also – Mac Shortcut Keys –  Bring out the Best of your Skills

  1. Shift+F6 > Previous Pane.
  2. Shift+F8 > Add to selection.
  3. Shift+F9 > Calculate active worksheet.
  4. Shift+F10 > Display shortcut menu.
  5. Shift+F11 > New worksheet.
  6. Shift+F12 >
  7. Ctrl+F3 > Insert Names.
  8. Ctrl+F4 >
  9. Ctrl+F5 > Restore window size.
  10. Ctrl+F6 > Next workbook window.
  11. Shift+Ctrl+F6 > Previous workbook window.
  12. Ctrl+F7 > Move window
  13. Ctrl+F8 > Resize window
  14. Ctrl+F9 > Minimize workbook
  1. Ctrl+F10 > Maximize or restore window
  2. Ctrl+F12 > Open File
  3. Alt+F1 > Insert Chart
  4. Ctrl+Shift+F6 > Previous Window
  5. Ctrl+Shift+F12 > Print
  6. Alt+Shift+F1 > New worksheet
  7. Alt+Shift+F2 > Save
  8. Ctrl+Shift+A > Insert argument names into formula
  9. Alt+Down arrow > Display AutoComplete list
  10. Alt+’ > Format Style dialog box
  11. Ctrl+Shift+~ > General format
  12. Ctrl+Shift+! > Comma format
  1. Ctrl+Shift+@ > Time format
  2. Ctrl+Shift+# > Date format
  3. Ctrl+Shift+$ > Currency format
  4. Ctrl+Shift+% > Percent format
  5. Ctrl+Shift+& > Place outline border around selected cells
  6. Ctrl+Shift+_ > Remove outline border
  7. Ctrl+Shift+* > Select current region
  8. Ctrl++ >Insert, (Rows, Columns, or Cells)
  9. Ctrl+1 > Format cells dialog box
  10. Ctrl+2 > Bold
  11. Ctrl+3 > Italic
  12. Ctrl+4 > Underline
  1. Ctrl+5 > Strikethrough
  2. Ctrl+6 > Show/Hide objects
  3. Ctrl+7 > Show/Hide Standard toolbar
  4. Ctrl+8 > Toggle Outline symbols
  5. Ctrl+9 > Hide rows
  6. Ctrl+0 > Hide columns
  7. Ctrl+Shift+ > Unhide rows
  8. Alt or F10 > Activate the menu
  9. Ctrl+Tab > next toolbar
  10. Shift+Ctrl+Tab > previous toolbar
  11. Ctrl+Tab > activate next workbook
  12. Shift+Ctrl+Tab > activate previous workbook
  13. Shift+Tab > Previous tool
  14. Shift+Ctrl+F > Font Drop Down List
  1. Shift+Ctrl+F+F > Font tab of Format Cell Dialog box
  2. Shift+Ctrl+P > Point size Drop Down List

0 comments:

Post a Comment

win back your ex here!

http://www.meetyoursweet.com?aff=subomi123&pg=2chwom

Secrets men don't want women to know

Copyright @ 2016 SINGLES' WORLD. Designed by Isaac IB | Love for Classysinglesworld Magazine