Shortcuts Keys for Microsft Excel

Every One is Learning Microsoft Office Basics of Word , Excel , Power Point and More. We are Providing the One of the Microsoft Excel in Ms Office.

excel.png

 

Here is the List of  Ultimate Shortcut Keys for Microsoft Excel . Helps you to learn Microsoft Excel Easily / Simpy…………!!!

 

F1 – Help.

 

F2 – Edit.

 

F3 – Paste Name.

 

F4 – Repaet Last Action.

F5 – Go to.

 

F6 – Next Pane.

 

F7 – Spell Check.

F8 – Extend Mode.

 

F9 – Recalculate all Workbooks.

F10 – Activate Menu Bar.

 

F11 – New chart.

F12 – Save As.

Alt + = – Autosum.

 

Ctrl +’ – Toglle Value / Formula Display.

 

Ctrl + Shift + A – Insert Argument Names Into Formula.

 

 

Alt + Down arrow – Display Auto Complete List.

Ctrl + F12 – File open.

 

Alt + F1 – Insert Chart.

Alt + F2 – Save as.

 

Alt + F4 – Exit.

 

Alt + F11 – Visula Basic Ediotr.

Ctrl + : – Insert Current time.

Ctrl + ; – Insert Current Date.

 

Ctrl +’’ – Copy Value From Cell Above.

Ctrl +’ – Copy Formula From cell Above.

 

Ctrl + Shift + ~ – general Format.

 

Ctrl + Shift +! – Comma Format.

Ctrl + Shift + @ – Time Format.

Ctrl + Shift + # – Date Format.

 

Ctrl + Shift + $ – Currency Form.

Ctrl + Shift + % – Percent Form.

 

Shift + Ctrl + F6 – Previous Workbook Window.

 

Ctrl + F7 – Move Window.

Ctrl + F8 – Resize window.

 

Ctrl + F9 – Minimize Workbook.

 

Ctrl + F10 – Maximize or Restore Window.

Ctrl + F11 – Inset 4.0 Macro Sheet.

 

Ctrl + F3 – Define Name.

Ctrl + F4 – Close.

 

Ctrl + F5 – XL , Restore Window Size.

Ctrl + F6 – Next workbook Window.

Ctrl + Shift + ^ – Exponential Format.

 

Ctrl + Shift + & – Place Outline Border Around Selected Cells.

Ctrl + Shift +_ – Remve Outline Border.

 

Ctrl ++ – Insert.

Ctrl + – – Delete.

 

Shift + F1 – what’s This ?.

Shift + F2 – Edit Cell Comment.

 

Shift + F3 – Paste Function Into Formula.

Shift + F4 – Find Next.

 

Shift + F5 – Find.

 

Shift + F6 -Previous Pane.

Shift + F8 – Add to selection.

 

Shift + F9 – Calculate Activate Worksheet.

Shift + F10 – Display Shortcut Menu.

Shift + F11 – New Worksheet.

 

Shift + F12 – Save.

 

Ctrl + Shift + F3 – Create Name By Using Names Of Row And Column Labels.

 

Ctrl + shift + F6 – Previous Windows.

Ctrl + Shift + F12 – Print.

 

Alt + Shift + F1 – New Worksheet.

Ctrl + A – Select All.

 

Ctrl + B – Bold.

 

Ctr + C – Copy.

Ctrl + D – Fill down.

Ctrl + F – Find.

Ctrl + G  – Go to.

 

Ctrl + H – Replace.

 

Ctrl + I – Itallic.

 

Ctrl + K – Insert Heyperlink.

 

Ctrl + O – Open.

 

Ctrl + P – Print.

 

Ctrl + R – Full Right.

 

Ctrl + S – Save.

 

Ctrl + U – Underline.

 

Ctrl + V – Paste.

 

Ctrl + W – Close.

Ctrl + X – Cut.

 

Ctrl + Y – Repeat.

Ctrl + z – Undo.

 

Ctrl + N – New Worksheet.

 

I Hope you’ve Understood Shortcut Keys for One of the Excel in Microsoft Office. If You have any doubts, comment below in the comment section and feel free to share this tips it to your friends ………!!!