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 ………!!!

Shortcut Keys for Ms Word

Are you Learning Ms Office without Knowing Any Shortcut keys . Here is the shortcut keys to learn  Ms Word . Let’s Have a Look Here To Use Shortcut Keys.

Microsoft-Word-2013-Logo-Web

 

Here is the List of  Ultimate Shortcut Keys for One of Ms Word in Ms Office.

Helps you to learn Ms Word Simply and Easily.

 

 

 

 

 

Ctrl + Home = Go to the beginning of document.

Ctrl + Enter = Page Break.

Ctrl + Delete = Delete one word to the right.

Ctrl + Backspace = Delete one word to the right.

Ctrl + TAB = Insert a tab character.

Ctrl + Alt + s = Copyright Symbol.

Ctrl + Alt + R = Registered Trademark symbol.

Ctrl + Alt+ T = Trade mark symbol.

Ctrl + Alt + M = Insert a Comment.

Ctrl + Alt + I = Switch in or out of print preview.

Ctrl + X = Cut text.

Ctrl + Y = Redo an action Previously Undone or Repeat an action.

Ctrl + Z = Undo a Previous action.

Ctrl + ] = Increase Of  Selected text by one Point.

Ctrl + [ = Decrease size of selected text by one point.

Ctrl + Shift + > = Increase font size.

Ctrl + Shift + < = decrease font size.

Ctrl + 1 = Single Space Lines.

Ctrl + 2 = Double – space lines.

Ctrl + 5 = 1.5 Space lines.

Ctrl + 0 = Add/ Remove one line space preceding a paragraph.

Ctrl + Left arrow = Move one word to the left.

Ctrl + Right arrow = Move one word to the right.

Ctrl + Up Arrow = Move one paragraph up.

Ctrl + Down Arrow = Move one paragraph down.

Ctrl + Page Up = Go to the top of previous page.

Ctrl + Page down = Go to the top of next page.

Ctrl + END = Go to end of the document.

Ctrl + Shift + C = Copy Formats.

Ctrl + Shift + D = Double Underline text.

Ctrl + Shift + E = Track changes.

Ctrl + Shift + F =change the font.

Ctrl + Shift + H = Apply hidden text Formatting.

Ctrl + Shift + K = Format letters as small capitals.

Ctrl + Shift + L = Apply the List style.

Ctrl + Shift + M = Remove a paragraph indent from the left.

Ctrl + Shift + N = Apply the Normal Text.

Ctrl + Shift + P = Change the font Size.

Ctrl + Shift + Q = Change the selection to the symbol font.

Ctrl + Shift + S = Apply a style.

Ctrl + Shift + T = Redcuce a hanging Indent.

Ctrl + Shift + V = Paste Format.

Ctrl + Shift + W = Underline Words But Not Space.

Ctrl + O = Open an existing word document.

Ctrl + P = Print word Document.

Ctrl + Q = Remove paragraph formatting.

Ctrl + R = Right align text.

Ctrl + S = Save word document.

Ctrl + T = Create a hanging indent.

Ctrl + U = Underline Text.

Ctrl + V = Paste text.

Ctrl + W = Close word document.

Ctrl + H = Repalce text another text [or] Replace text with different formatting.

Ctrl + I = Italicize Text.

Ctrl + J = Justify Text.

Ctrl + K = Open insert Hyperlink window.

Ctrl + L = Left aligh Text.

Ctrl + M = Indent a paragraph from the left.

Ctrl + N = Open new word Document.

Ctrl + A = Select text.

Ctrl + B = Bold Text.

Ctrl + C = Copy text.

Ctrl + D = Open font Formatting Window.

Ctrl + E = Center text.

Ctrl + F = Find a Phrase.

Ctrl + G = Go to a Specfic page [or] Book Mark.

 

 

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