Hello Friends! Welcome to My Blog Solution Theoretical, This blog is for you, and I want to give complete mathematics and Other solution, I will glad to giving best solution.

Saturday 10 March 2018

230 MS-Excel shortcuts for Windows

MS-Excel shortcuts for Windows 

File Key Shortcuts

  1. Ctrl + N ➨ Create New Workbook  
  2. Ctrl  + O  ➨ Open Workbook  
  3. Ctrl + S ➨ Save Workbook  
  4. F12   ➨ Save as 
  5. Ctrl +P ➨ Print
  6. Ctrl +F2  ➨ for  open print preview window
  7. Ctrl + W  Or Ctrl +F4 ➨ To close correct workbook
  8. Alt + F4 ➨ Close Excel

Ribbon Key Shortcuts 

  1.  Ctrl + F1 ➨ Expand or collapse ribbon
  2. Alt  ➨ Activate Access Keys
  3. Tab  ➨ move to next ribbon control
  4. Space ➨ Activate or open selected  control
  5.  Enter ➨ Confirm Control Change
  6. F1 ➨ Get help for selected Control

General Key Shortcuts 

  1. Ctrl + Z  ➨ Undo For Canceling last Operation
  2. Ctrl + Y ➨ Redo For Canceling  Undo
  3. F4➨  Repeat last Action (for make value absolute)
  4. Ctrl + C ➨  Copy Selected Cells
  5. Ctrl + X  ➨ Cut Selected Cells
  6. Ctrl + V ➨  Paste Content From clipboard
  7. Ctrl + Alt + V ➨ Display the paste Special Dialog Box
  8. Ctrl + F  ➨ Display the Find Dialog box
  9. Ctrl + H ➨ Display the Replace Dialog box
  10. Shift+ F4 ➨  Find Next match
  11. Ctrl + Shift + F4  ➨ Find Previous match
  12. Alt + F1  ➨Create Embedded Chart
  13. F11 ➨  Create Chart in New Worksheet
  14. Ctrl + Shift + L   ➨ Toggle AutoFilter
  15. Alt + ↓  ➨ Activate Filter
  16. Ctrl + T  ➨Insert Table
  17. Shift + Space  ➨ Select Table Row
  18. Ctrl + Space ➨  Select table Column
  19. Ctrl + A  ➨ Select table
  20. Alt + C  ➨ Clear Slicer Filter

Drag And Drop Related Task Key  Shortcuts

  1. Drag  ➨ Drag and Cut
  2. Ctrl + Drag  ➨Drag and Copy
  3. Shift + Drag  ➨ Drag and Insert
  4. Ctrl + Shift + Drag  ➨ Drag and Insert Copy
  5. Alt + Drag  ➨ Drag to Worksheet
  6. Ctrl + Drag  ➨ Drag to Duplicate Worksheet

Navigation Key Shortcuts 

  1. →    ➨ Move one Cell Right
  2. ←    ➨  Move One Cell Left
  3. ↑      ➨  Move One Cell Up
  4. ↓     ➨ Move One Cell Down
  5. Alt + Page up  ➨ Move One Screen Left
  6. Alt + Page Down  ➨ Move One Screen Right
  7. Page up  ➨ Move Screen Up
  8. Page Down  ➨ Move Screen Down
  9. Ctrl + →    ➨   Move to Right Edge of data region
  10. Ctrl + ←    ➨   Move to Left Edge of data region
  11. Ctrl + ↑      ➨   Move to Top Edge of data region
  12. Ctrl + ↓      ➨   Move to Bottom Edge of data region
  13. Home        ➨   Move to beginning of  Row
  14. Ctrl + End  ➨  Move To last Cell in Worksheet
  15. Ctrl + Home  ➨ Move To First Cell  in Worksheet
  16. End ➨ Turn End Mode On

Selection Key Shortcuts 

  1. Shift + Space ➨  Select Entire Row
  2. Ctrl + Space ➨ Select Entire Column
  3. Ctrl + A  ➨ Select Entire Worksheet
  4. Shift + Click  ➨ Add adjacent Cells to Selection
  5. Ctrl + Alt  + ←    ➨ Move Left between Non-Adjacent Selections
  6. Ctrl + Alt + →    ➨ Move Right  between Non-Adjacent Selections
  7. Shift + F8 ➨  Toggle add to Selection Mode
  8. Esc  ➨ Cancel Selection

Active Cell Key Shortcuts

  1. Shift + Backspace ➨  Select active cell only
  2. Ctrl + Backspace  ➨ Show the active cell on Worksheet
  3. Ctrl + .   ➨ Move active cell Clockwise in Selection  
  4. Enter  ➨ Move active cell down in selection
  5. Shift + enter  ➨ Move active Cell up in Worksheet
  6. Tab ➨  Move Active Cell Left in a selection
  7. Shift + Tab ➨  Move active cell right in selection

Extend Selection Key Shortcuts

  1. Shift + →    ➨  Extend selection by one cell right
  2. Shift + ←    ➨ Extend Selection By One Cell Left
  3. Shift + ↑      ➨  Extend Selection By One Cell Up
  4. Shift + ↓      ➨ Extend Selection By One Cell Down
  5. Ctrl + Shift + →    ➨   Extend the selection to the last cell right
  6. Ctrl + Shift + ←   ➨  Extend the selection to the last cell Left

  8. Ctrl + Shift + ↑    ➨   Extend the Selection to the last Cell Up
  9. Ctrl + Shift + ↓      ➨   Extend the Selection to the last Cell Down
  10. Shift + Page Up   ➨   Extend selection up one Screen
  11. Shift + Page down    ➨ Extend selection Down one Screen
  12. Alt + Shift + Page down   ➨   Extend selection Right one Screen
  13. Alt + Shift + Page up   ➨  Extend selection Left one Screen
  14. Shift + Home   ➨  Extend Selection to Start of Row
  15. Ctrl + Shift + Home   ➨  Extend Selection to first cell in worksheet
  16. Ctrl + Shift + End  ➨  Extend Selection to Last cell in worksheet
  17. F8  ➨ Toggle extend selection Mode

Special Selection in Worksheet Key Shortcuts

  1. Ctrl + G    ➨ Display “Go to”  Dialog Box
  2. Ctrl + Shift + O   ➨ Select Cell With Comment
  3. Ctrl + Shift + *   ➨  Select Current region around active Cell
  4. Ctrl + A    ➨ Select Current region
  5. Ctrl + /    ➨ Select Current Array
  6. Ctrl + \    ➨ Select Row Differences
  7. Ctrl + Shift +|     ➨ Select Column Differences
  8. Ctrl + [    ➨ Select  Direct Precedents
  9. Ctrl + shift + {    ➨ Select all Precedents
  10. Ctrl + ]    ➨ Select  Direct Precedents
  11. Ctrl + shift + }    ➨ Select all Precedents
  12. Alt + ;    ➨ Select Visible cell Only

Cell Edit Mode Key Shortcuts

  1. F2    ➨ Edit the Active Cell
  2. Shift + F2    ➨ Insert or Edit Comment
  3. Esc    ➨ Cancel Entry
  4. Shift + →    ➨ Select One Character Right
  5. Shift + ←    ➨ Select One Character Left
  6. Ctrl + →    ➨ Move One Word Right
  7. Ctrl + ←    ➨ Move One Word Left
  8. Ctrl + Shift + →    ➨ Select One Word Right
  9. Ctrl + Shift +←   ➨ Select One Word Left
  10. Shift + Home    ➨ Select to Beginning of cell
  11. Shift + End    ➨ Select to end of Cell
  12. Ctrl + Delete    ➨ Delete to end of Line
  13. Backspace    ➨ Delete Character to the of Curser
  14. Delete    ➨ Delete Character to the right of Curser
  15. Alt + Enter    ➨ Start a New line in the Same Cell

Entering Data Key Shortcuts 

  1. Enter    ➨ Enter and Move Down
  2. Shift + Enter    ➨  Enter and Move Up
  3. Tab ➨ Enter and Move Right
  4. Shift + Tab ➨  Enter and Move Left
  5. Ctrl + Enter ➨ Complete entry and Stay in same Cell
  6. Ctrl + Enter ➨ Enter Same Data In Multiple Cell
  7. Ctrl + ;  ➨ To Insert Current Date
  8. Ctrl + Shift + ;    ➨ To Insert Current Time
  9. Ctrl + D  ➨ Fill Down from Cell Above
  10. Ctrl + R   ➨ Fill Right From Cell Left
  11. Ctrl + ‘  ➨ Copy Formula From Cell Above
  12. Ctrl + Shift + “   ➨  Copy Value From Cell Above
  13. Ctrl + K  ➨ For Adding Hyperlink
  14. Alt + ↓  ➨ Display Auto Complete List
  15. Ctrl + E  ➨ Flash Fill

Formatting Key Shortcuts

  1. Ctrl + 1 ➨  Format anything
  2. Ctrl + Shift + F ➨  Display Format Cells with Font tab Selection
  3. Ctrl + B  ➨ Apply Or Remove Bold Formatting
  4. Ctrl + I ➨ Apply Or Remove Italic Formatting
  5. Ctrl + U  ➨ Apply or Remove Underline Formatting
  6. Ctrl + 5  ➨ Apply or Remove Strike through Formatting
  7. Alt + H+ A+ C  ➨ Align Center
  8. Alt + H+ A+ L  ➨ Align Left
  9. Alt + H+ A+ R  ➨ Align Right
  10. Alt + H+ 6 ➨ Indent
  11. Alt + H + 5  ➨ Remove Indent
  12. Alt + H + FG ➨  Increase Font Size One Step
  13. Alt + H + FK  ➨ Decrease Font Size One Step

Number Formatting Key Shortcuts

  1. Ctrl + Shift  +  ~   ➨ Apply General Format
  2. Ctrl + Shift + $  ➨ Apply Currency Format
  3. Ctrl + Shift + %  ➨ Apply Percentage Format
  4. Ctrl + Shift + ^  ➨ Apply Scientific Format
  5. Ctrl + Shift + #  ➨ Apply date Format
  6. Ctrl + Shift + @  ➨ Apply Time Format
  7. Ctrl + Shift + !  ➨ Apply Number Format

Border Key Shortcuts

  1. Ctrl + Shift + &  ➨ Add Border Outline
  2. Alt + R  ➨ Add or Remove Border Right
  3. Alt + L   ➨ Add or Remove Border Left
  4. Alt + T  ➨ Add or Remove Border Top
  5. Alt + B  ➨ Add or Remove Border Bottom
  6. Alt + D  ➨ Add or Remove Border Upward Diagonal
  7. Alt + H  ➨ Add or Remove Border Horizontal Interior
  8. Alt + V  ➨ Add or Remove Border Vertical Interior
  9. Ctrl + Shift + _  ➨ Remove Borders

Excel Formulas Key Shortcuts

  1. F4  ➨ Toggle absolute and relative references
  2. Shift + F3  ➨ Open the Insert Function Dialog Box
  3. Alt + Equal Sign (=)  ➨Auto sum selected Cells
  4. Ctrl + `  ➨ Toggle Formulas On and Off
  5. Ctrl + Shift + A I ➨ insert Function Arguments
  6. Ctrl + Shift + Enter  ➨ Enter Array Formula
  7. F9  ➨ Calculate Worksheet
  8. Shift + F9  ➨ Calculate active Worksheet
  9. Ctrl + Shift + F9  ➨ Force calculate all Worksheet
  10. F9  ➨ Evaluate part of a Formula
  11. Ctrl + Shift + U  ➨ Expend or Collapse the Formula bar
  12. Ctrl + A  ➨ Display Function Arguments Dialog Box
  13. Ctrl + F3  ➨ Define Name
  14. Ctrl + Shift + F3  ➨ Define Name using row and column labels
  15. F3 ➨ Paste name into Formula
  16. Tab ➨  Accept Function with autocomplete

Grid Operations Key Shortcuts

  1. Ctrl + Shift + Plus Sign ➨  Display Insert Dialog Box
  2. Ctrl + Shift + Plus Sign ➨  Insert Row
  3.  Ctrl + Shift + Plus Sign ➨  Insert Column
  4. Ctrl +  Minus Sign  ➨ Display Delete Dialog Box
  5. Ctrl +  Minus Sign  ➨ Delete Column
  6. Ctrl +  Minus Sign  ➨  Delete Row
  7. Ctrl +  Minus Sign  ➨ Delete Cells
  8. Delete  ➨ Delete Contents of Selected cell
  9. Ctrl + 0  ➨ Hide Content
  10. Ctrl + 9 ➨  Hide Rows
  11. Ctrl + Shift + 9  ➨ Unhide Rows
  12. Ctrl + Shift + 0  ➨ Unhide Column
  13. Alt + Shift + →  ➨ To Group Row or Column
  14. Alt + Shift + ←  ➨ To Ungroup Row or Column
  15. Alt + Shift + →  ➨ To Open Group Dialog Box
  16. Alt + Shift + ←  ➨ To Open Ungroup Dialog Box
  17. Ctrl + 8  ➨ Hide or Show Out Line Symbols
  18. Ctrl + Alt + Plus  ➨ Sign  For Zoom In
  19. Ctrl + Alt + Minus Sign   ➨ For Zoom Out

Pivot Tables Key Shortcuts

  1. Ctrl + A   ➨ Select Entire Pivot Table
  2. Space ➨ Toggle Pivot table Field Checkbox
  3. Alt + Shift + →  ➨ Group Pivot table Items
  4. Alt + Shift +← ➨ Ungroup Pivot table Items
  5. Ctrl +  Minus Sign  ➨ Hide Pivot Table Items
  6. Alt + F1  ➨ Create Pivot Chart on Same Worksheet
  7. F11 ➨  Create  Pivot Chart On New Worksheet
  8. Alt + D + P  ➨ Open Pivot Table Wizard

Workbook Key Shortcuts

  1. Shift + F11  ➨ Insert New Worksheet
  2. Ctrl + Page Down  ➨ Go to Next Worksheet
  3. Ctrl + Page Up  ➨ Go to Previous Worksheet
  4. F6  ➨ Move to Next Pane
  5. Shift + F6 ➨  Move to Previous pane
  6. Ctrl + Tab  ➨ Go to Next Workbook
  7. Ctrl + Shift + Tab  ➨  Go to Previous Workbook
  8. Ctrl + F9   ➨ Minimize current Workbook Window
  9. Ctrl +F10 ➨  Maximize the Current Workbook Window
  10. Shift + Click  ➨  Select Adjacent Worksheets
  11. Ctrl + Click   ➨ Select Non-Adjacent Worksheets
  12. Scroll Lock  ➨ Toggle Scroll Lock
  13. Ctrl + Shift + F1  ➨ Toggle Full Screen Excel Dialog Boxes
  14. Tab  ➨ Move to Next Control
  15. Shift + tab  ➨ Move to Previous Control
  16. Ctrl + Tab  ➨  Move to Next Tab
  17. Ctrl + Shift + Tab  ➨  Move to Previous Tab
  18.  Enter  ➨ Accept and Apply  
  19. Space ➨  Check and Uncheck Box
  20. Esc  ➨ Cancel and Close the Dialog Box

Other Key Shortcuts

  1. F7  ➨ Open Spelling Dialog Box
  2. Shift + F7  ➨ Open thesaurus Dialog Box
  3. Alt + F8  ➨ Open Macros Dialog Box
  4. Alt + F11  ➨ Open VBA Editor
  5. Ctrl + D ➨ Duplicate Object
  6. Alt  ➨ Snap to Grid
  7. Ctrl + 6  ➨ Hide of Show Objects
  8. Alt + ‘  ➨ Display Modify Cell style Dialog Box
  9. Shift + F10  ➨ Display Right Click menu
  10. Shift + F10 + D   ➨ Delete Content
  11. Alt+ Space ➨  Display Control menu
















  








































Posted on at

2 comments:

  1. Warnerhill12 June 2019 at 04:48

    Your blog is good and informative. Keep sharing regular content on this blog. Excel Search and Replace

    ReplyDelete
  2. Krishna Optif27 January 2020 at 03:02

    very nice and provide me informative content thanks for sharing for more information about how to Create new Workbook

    ReplyDelete

Subscribe to: Post Comments (Atom)

क्या आप जानते है कि Master Card, Rupay Card और Visa card में अन्तर क्या है

क्या आप जानते है की Master Card, Rupay Card और  Visa card  में अन्तर क्या है दोस्तों क्या आप जानते है की Master Card, Rupay Card औ...