MS Excel Shortcuts



Shortcuts
Description

  • F2                    

  • edit the selected cell

  • F5 

  • go to specified sale for example C6

  • F7 

  • spell check selected text and or document

  • F11 

  • create chart

  • Ctrl + shift +;

  • enter the current time

  • Ctrl +; 

  • enter the current date

  • Alt + shift + F1 

  • insert new worksheet

  • Shift+ F3 

  • open the Excel formula window

  • Shift + F5

  • bring up search box

  • Ctrl+A

  • Select all contents of the worksheet

  • Ctrl + I 

  • italic highlighted selection

  • Ctrl + k

  • insert link

  • Ctrl + u

  • underline the selection

  • Ctrl + 5
  • Ctrl + Z 

  • strikethrough highlighted selection
  • Undo  Changes

  • Ctrl +F9

  • minimise the current window

  • Ctrl + F10

  • maximize currently selected Windows

  • Ctrl + F6

  • switch between open workbooks / Windows

  • Ctrl + page up 

  • move between excel worksheet s in the same Excel document

  • Ctrl + page down

  • between shit in the same Excel document



  • Ctrl+ tab 

  • move between two or more open Excel files

  • ALT + = 

  • create a formula to sum all of the above cells

  • Ctrl +'  

  • insert the value of the above cell into the cell currently selected

  • Ctrl + shift +! 

  • format number in comma format


  • Ctrl + shift +$
  • Ctrl + shift + # - 

  • format number in currency format
  • format number in date format

  • Ctrl + shift +%

  • format number in percentage format

  • Ctrl + shift +^ 

  • format number in scientific format

  • Ctrl + shift + @ 

  • format number in time format



  • Ctrl + Arrow key

  • to next selection of next

  • Ctrl + space  

  • select entire column

  • Shift + space

  • select entire row

Related Post


Post a Comment

Previous Post Next Post

Contact Form