Ms Excel 100+ shortcut keys for biginner | technomintstudy

Pratima verma

Microsoft excel 2007 basic shortcut keys for beginers

 Microsoft excel 2007 shortcut key:-

  1. Ctrl+0 =hide selected column in Microsoft excel
  2. Ctrl +1 =display formate cell dialog box
  3. Ctrl +2 =applies or romove bold formatting 
  4. Ctrl +3 =applies or romove italic formatting 
  5. Ctrl +4 =applies or romove underlining in Microsoft excel 
  6. Ctrl +5 =applies or romone strikethrough 
  7. Ctrl +6 =alternate between hiding objects, displaying objects and displaying place holders for object 
  8. Ctrl +8 =display or hide outline symbol 
  9. Ctrl +9 =hide the selected row
You may also like...

Use of function keys in excel:-

  1. F1 =displays the Microsoft office excel help desk 
  2. Ctrl +F1 =display or hide the ribbon 
  3. Alt+F1 =create is chart of data in the current page
  4. Alt+shft +F1 =insert new worksheet
  5. F2 =edit the active cell and position the insertion point at the end of a cell content. It also moves the insertion point into the formula bar when editing in a cell is turned off
  6. Shift +F2 =adds or edit a cell comment 
  7. Ctrl +F2 =displays the print preview window 
  8. F3 =displays the paste name dialog box
  9. Shft+F3 =displays the insert function dialog box
  10. F4 =repeat the last command or option 
  11. Ctrl +F4 =close the selected workbook window 
  12. F5=displays the go to dialog box
  13. F6 =switches between the worksheet, ribbon task pane and Zoom control. In a worksheet that has been split (view menu manage this window, freeze panes, split window cammand) F6 includes the split panes when switching between panes and ribbon area
  14. F7 =displays the spelling dialog box to cheak spelling in selected area
  15. F8 =turns extend mood on or off
  16. F9 =calculates all worksheet in all open workbook
  17. F10 =turns key tip on or off
  18. Shift +F10 =displays Shortcut menu for a selected item in excel
  19. F11 =create a chart of a data in current range
  20. Shift +F11 =insert a new worksheet 
  21. Alt+F11 =opens the ms visual basic editor, in which you can create a micro by using visual basic for application (vba)
  22. F12 =displays the save as dialog box       Special character keys :-
  23. Ctrl shift ~=applies the general number formate in Microsoft excel
  24. Ctrl shift plus ( ) =displays the insert dialog box to insert blank in Microsoft excel
  25. Ctrl +; =enter the current date
  26. Ctrl + = alternate between displaying all value and displaying formula in the worksheet
  27. Ctrl +minus(-) =displays the delete dialog box to delete the selected cell
  28. Ctrl +shift _ =remove outline border from selected cell
  29. Ctrl + shift + =copies the value from the cell above the active cell into the cell or formula box
  30. Ctrl +shift +! =applies the number formate with two decimal place, thousand separater and minus sign (-) for negative value
  31. Ctrl +shift +# =applies the date formate with the day month and year
  32. Ctrl +shift+$ =applies the currency formate with two decimal place (negative number in parenthes)
  33. Ctrl +shift +% =applies the percentage formate with no decimal place 
  34. Ctrl +shift+& =applies the outline border to selected cell
  35. Ctrl +shift +( =unhide any hidden row within the selection
  36. Ctrl +shift +) =unhide any hidden column within the selection
  37. Ctrl +shift * =select the current region around the active call (the data area enclosed by blank rows and blank column) in a pivot table, it selects the entire pivot table report
  38. Ctrl +shift +: =enters current time
  39. Ctrl +shift +@ =applies the time formate with the hour and minutes and am or pm
  40. Ctrl +shift +^ =applies the exponential number formate with two decimal place

Alphabet Shortcut key:-

  1. Ctrl +a: =select enter worksheet
  2. Ctrl +b: =applies or removes bold formatting
  3. Ctrl +c =copies the selected cell
  4. Ctrl +c+ctrl+c =displays the clipboard
  5. Ctrl +d =uses the fill down cammand to copy the contents and formate of the top most cell of a selected range into the cells below
  6. Ctrl +f =display the find and replace dialog box with the find tab selected
  7. Shift +f5 =display the find and replace dialog box
  8. Shift +f4 =repeats the last find action
  9. Ctrl +shift+f =open the formate cell dialog box with the font tab selected
  10. Ctrl +g =displays the go to dialog box
  11. Ctrl +h =displays the find and replace dialog box with replace tab selected 
  12. Ctrl +i = applies or remove italic formating in Microsoft excel.
  13. Ctrl+ k= displays the insert hyperlink dialog box for new hyperlink or the edit hyperlink dialog box for selected existing hyperlink. 
  14. Ctrl+n= create a new, blank workbook.
  15. Ctrl +o= displays the open dialog box to open or find a file. 
  16. Ctrl+sift +o= select all cell that contains comment.
  17. Ctrl +p= displays the print dialog box. 
  18. Ctrl +sift+p= opens the formate cell dialog box with the font tab selected.
  19. Ctrl +r = uses the fill right command to copy the content and formate of the leftmost cell of a selected range into the cell to the right. 
  20. Ctrl +s = saves the active file with its corrent file name,location and file formate.
  21. Ctrl+ u= applies or remove underlining. 
  22. Ctrl+ shift +u= switches between expanding and collapsing of formula bar.
  23. Ctrl +v= insert the content of clip board at the insertion point and replaces any selection.
  24. Ctrl+w= closes the selected workbook window. 
  25. Ctrl+x= cuts the selected cell
  26. Ctrl+z= undo 
  27. ctrl +shift +z= redo. 
  28. Esc = cancel an entry in the cell or formula bar. 
You may also like ...

     Priyanshu Verma
     Instagram

      Twitter

        Koo