Blogs

Posted On : 15th November 2017

Microsoft - Excel Shortcut Keys - Important For Competitive Exams

F2 Edit the selected cell

F5 Go to a specific cell

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 worksheet

Ctrl + B Bold highlighted selection

Ctrl + I Italicize highlighted selection

Ctrl + C Copy selected text

Ctrl + V Paste

Ctrl + D Fill

Ctrl + K Insert link

Ctrl + F Open find and replace options

Ctrl + G Open go-to options

Ctrl + H Open find and replace options

Ctrl + U Underline highlighted selection

Ctrl + Y Underline selected text

Ctrl + 5 Strikethrough highlighted selection

Ctrl + O Open options

Ctrl + N Open new document

Ctrl + P Open print dialog box

Ctrl + S Save

Ctrl + Z Undo last action

Ctrl + F9 Minimize current window

Ctrl + F10 Maximize currently selected window

Ctrl + F6 Switch between open workbooks/windows

Ctrl + Page up & Page Down Move between Excel worksheets in the same document

Ctrl + Tab Move between two or more open Excel files

Alt + = Create formula to sum all of above cells

Ctrl + ‘ Insert value of above cell into current cell

Ctrl + Shift + ! Format number in comma format

Ctrl + Shift + $ Format number in currency format

Ctrl + Shift + # 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 + g Move to next section of text

Ctrl + Space Select entire column

Shift + Space Select entire row

Ctrl + W Close document

 

Add your comment