MS OFFICE KE SARE SHORTCUT YAHA SE SIKHO

MICROSOFT OFFICE ALL SHORT KEY

·         Ctrl+N :-Use For New Workbook Create

·         Ctrl+O: Open Excisting Workbook

·         Ctrl+S: Use For Save A Workbook

·         F12: Use For Open The Save As Dialog Box

·         Ctrl+W: Use For Close A Workbook

·         Ctrl+F4: Use For Close Excel

·         F4: Use For Repeat The Last Command Or Action. Use For Example, If The Last Thing You Typed In A Cell Is “Computer,” Or If You Change The Font Color, Clicking Another Cell And Pressing F4 Repeats That Action In The New Cell.

·         Shift+F11: Use For Insert A New Worksheet

·         Ctrl+Z: Use For Undo An Action

·         Ctrl+Y: Use For Redo An Action

·         Ctrl+F2: Use For Switch To Print Preview

·         F1: Use For Open The Help Pane

·         Alt+Q: Go To The “Tell Me What You Want To Do” Box

·         F7: Use For Check Spelling

·         F9 -: Calculate All Worksheets In All Open Workbooks

·         Shift+F9 -: Use For Calculate Active Worksheets

·         Alt Or F10: Use For Turn Key Tips On Or Off

·         Ctrl+F1: Use For Show Or Hide The Ribbon

·         Ctrl+F9: Use For Minimize The Workbook Window

          Ctrl+Shift+U:Use For  Expand Or Collapse The Use Formula Bar

·         F11: Use For Create A Bar Chart Based On Selected Data (On A Separate Sheet)

·         Alt+F1: Use For Create An Embedded Bar Chart Based On Select Data (Same Sheet)

·         Ctrl+F: Use For Search In A Spreadsheet, Or Use Find And Replace

·         Alt+F: Use For Open The File Tab Menu

·         Alt+H: Use For Go To The Home Tab

·         Alt+N: Use For Open The Insert Tab

·         Alt+P: Use For Go To The Page Layout Tab

·         Alt+M: Use For Go To The Use Formulas Tab

·         Alt+A: Use For Go To The Data Tab

·         Alt+R: Use For Go To The Review Tab

·         Alt+W: Use For Go To The View Tab

·         Alt+X: Use For Go To The Add-Ins Tab

·         Alt+Y: Use For Go To The Help Tab

·         Ctrl+Tab: Use For Switch Between Open Workbooks

·         Shift+F3: Use For Insert A Function

·         Alt+F8: Use For Create, Run, Edit, Or Delete A Macro

·         Alt+F11: Use For Open The Microsoft Visual Basic Use For Applications Editor

Moving Around In A Worksheet Or Cell

·         Left/Right Arrow: Use For Move One Cell To The Left Or Right

·         Ctrl+Left/Right Arrow: Use For Move To The Farthest Cell Left Or Right In The Row

·         Up/Down Arrow: Use For Move One Cell Up Or Down

·         Ctrl+Up/Down Arrow: Use For Move To The Top Or Bottom Cell In The Column

·         Tab: Use For Go To The Next Cell

·         Ctrl+End: Use For Go To The Most Bottom Right Used Cell

            Shift+Tab: Use For Go To The Previous Cell

·         F5: Use For Go To Any Cell By Pressing F5 And Typing The Cell Coordinate Or Cell Name.

·         Home: Use For Go To The Leftmost Cell In The Current Row (Or Go To The Beginning Of The Cell If Editing A Cell)

·         Ctrl+Home: Use For Move To The Beginning Of A Worksheet

·         Page Up/Down: Use For Move One Screen Up Or Down In A Worksheet

·         Alt+Page Up/Down: Use For Move One Screen To The Right Or Left In A Worksheet

·         Ctrl+Page Up/Down: Use For Move To The Previous Or Next Worksheet

Selecting Cells

·         Shift+Left/Right Arrow: Use For  Extend The Cell Selection To The Left Or Right 

·         Ctrl+Space: Use For Select The Entire Column

       Shift+Space: Use For Select The Entire Row

·         Ctrl+Shift+Space: Use For Select The Entire Worksheet

Editing Cells

·         F2: Use For Edit A Cell

·         Shift+F2: Use For Add Or Edit A Cell Comment

·         Ctrl+X: Use For Cut Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Ctrl+C Or Ctrl+Insert: Use For Copy Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Ctrl+Alt+V: Use For Open The Paste Special Dialog Box

       Ctrl+V Or Shift+Insert: Use For Paste Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Delete:Use For Remove The Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Alt+Enter: Use For Insert A Hard Return Within A Cell (While Editing A Cell)

·         F3: Use For Paste A Cell Name (If Cells Are Named In The Worksheet)

·         Alt+H+D+C: Use For Delete Column

·         Esc: Use For Cancel An Entry In A Cell Or The Use Formula Bar

·         Enter: Use For Complete An Entry In A Cell Or The Use Formula Bar

Use Formatting Cells

·        0 Ctrl+B: Use For Add Or Remove Bold To The Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Ctrl+I: Use For Add Or Remove Italics To The Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Ctrl+U: Use For Add Or Remove Underline To The Contents Of A Cell, Selected Data, Or Selected Cell Range

·         Alt+H+H: Use For Select A Fill Color

·         Alt+H+B: Use For Add A Border

·         Ctrl+Shift+&: Use For Apply Outline Border

·         Ctrl+Shift+_ (Underline): Use For Remove Outline Border

·         Ctrl+9: Use For Hide The Selected Rows

·         Ctrl+0: Use For Hide The Selected Columns

·         Ctrl+1: Use For Open The Use Format Cells Dialog Box

         Ctrl+Shift+$: Use For Apply Currency Use Format

·         Ctrl+5: Use For Apply Or Remove Strikethrough\

·       Ctrl+Shift+%: Use For Apply Percent Use Format

 

---

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH