Keyboard shortcuts are a game-changer when it comes to maximizing productivity in Excel. Whether you're a beginner or a seasoned pro, knowing the right shortcuts can save you valuable time and effort. In this guide, we'll explore a comprehensive list of Excel shortcuts for Windows users, covering everything from basic navigation to advanced formatting and data manipulation.
Frequently Used Shortcuts( अक्सर उपयोग किये जाने वाले शॉर्टकट)
Let's start with some of the most commonly used shortcuts in Excel
- Close a workbook: Ctrl+W
- Open a workbook: Ctrl+O
- Go to the Home tab: Alt+H
- Save a workbook: Ctrl+S
- Copy selection: Ctrl+C
- Paste selection: Ctrl+V
- Undo recent action: Ctrl+Z
- Remove cell contents: Delete
- Choose a fill color: Alt+H, H
- Cut selection: Ctrl+X
Ribbon Keyboard Shortcuts ( रिबन कीबोर्ड शॉर्टकट )
The ribbon in Excel organizes related options into tabs. Here are some shortcuts for navigating the ribbon efficiently.
- Move to the Tell Me or Search field: Alt+Q
- Open the File menu: Alt+F
- Open the Home tab: Alt+H
- Open the Insert tab: Alt+N
- Open the Page Layout tab: Alt+P
- Open the Data tab: Alt+A
- Open the Review tab: Alt+R
- Open the View tab: Alt+W
Navigation Shortcuts( ऊपर निचे जानेवाली या करने वाली )
Efficient navigation is key to working swiftly in Excel. Here are some essential navigation shortcuts.
- Move one cell up: Up arrow key
- Move one cell down: Down arrow key
- Move one cell left: Left arrow key
- Move one cell right: Right arrow key
- Move to the edge of the current data region: Ctrl+Arrow key
- Enter the End mode: End, Arrow key
- Move to the last cell on a worksheet: Ctrl+End
- Extend the selection of cells to the last used cell on the worksheet: Ctrl+Shift+End
Formatting Shortcuts ( सजावट करने वाली कुंजी )
Formatting data is a common task in Excel. These shortcuts will make the process smoother.
- Open the Format Cells dialog box: Ctrl+1
- Format fonts: Ctrl+Shift+F or Ctrl+Shift+P
- Insert a note: Shift+F2
- Open the Insert dialog box: Ctrl+Shift+Plus sign (+)
- Open the Delete dialog box: Ctrl+Minus sign (-)
- Enter the current time: Ctrl+Shift+Colon (:)
- Enter the current date: Ctrl+Semicolon (;)
Selection and Action Shortcuts ( किसी भी प्रकार का चयन करने वाली कुंजी )
Selecting cells and performing actions efficiently is crucial. Here are some handy shortcuts.
- Select the entire worksheet: Ctrl+A or Ctrl+Shift+Spacebar
- Extend the selection of cells by one cell: Shift+Arrow key
- Fill the selected cell range with the current entry: Ctrl+Enter
- Complete a cell entry and select the cell above: Shift+Enter
- Select an entire column: Ctrl+Spacebar
- Select an entire row: Shift+Spacebar
Working with Data and Formulas ( डेटा और फ़ॉर्मूले के साथ कार्य करना )
Manipulating data and formulas is a core aspect of Excel. Here are some shortcuts for working with data.
- Turn on or off tooltips for checking formulas: Ctrl+Alt+P
- Edit the active cell: F2
- Expand or collapse the formula bar: Ctrl+Shift+U
- Cancel an entry in the cell or formula bar: Esc
- Move the cursor to the end of the text in the formula bar: Ctrl+End
- Select all text in the formula bar: Ctrl+Shift+End
- Calculate all worksheets in all open workbooks: F9
Refreshing External Data ( बाहरी डेटा ताज़ा करना )
If you're working with external data sources, these shortcuts will come in handy.
- Stop a refresh operation: Esc
- Refresh data in the current worksheet: Ctrl+F5
- Refresh all data in the workbook: Ctrl+Alt+F5
Power Pivot Shortcuts ( पावर पिवोट शॉर्टकट )
For those leveraging Power Pivot, here are some useful shortcuts,
- Open the context menu for the selected cell, column, or row: Shift+F10
- Select the entire table: Ctrl+A
- Copy selected data: Ctrl+C
- Delete the table: Ctrl+D
Function Keys ( फ़ंक्शन कुंजियां )
Lastly, here are some function key shortcuts for various tasks in Excel.
- F1: Displays Excel Help
- F2: Edit the active cell
- F3: Displays the Paste Name dialog box
- F4: Repeats the last command or action
- F5: Displays the Go To dialog box
- F6: Switches between the worksheet, ribbon, and task pane
- F7: Opens the Spelling dialog box
- F8: Turns extend mode on or off
- F9: Calculates worksheets
- F10: Turns key tips on or off
No comments:
Post a Comment