MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

नमस्ते दोस्तों आज हम MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़ के बारे में बात करने वाले हैं, तो दोस्तों हम आपके लिए MS Excel Shortcut Keys in Hindi पोस्ट लाए हैं, चले MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़  जाने हिंदी में। जानते हैं आपको बहुत सारी नॉलेज देगी, हमारी HindiYouth.com वेबसाइट का एक ही मकसद है कि हिंदुस्तान के युवाओं को सही जानकारी मिल सके.

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़
MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

दुनिया में बोहत सरे लोग असे है जो MS Excel Shortcut Keys जानना चाह ते है। तो चलिए जानते है

Drag and Drop

Shortcut Description

Alt + Drag Drag to worksheet

Ctrl + Drag Drag and copy or Drag to duplicate worksheet

Ctrl + Shift + Drag Drag and insert copy

Drag Drag and cut

Shift + Drag Drag and insert

Entering Data MS Excel Shortcut Keys

Shortcut Description

Ctrl + D Fill down from cell above

Ctrl + E Flash fill

Ctrl + K Add hyperlink

Ctrl + Shift + “ Copy value from cell above

Extend Selection

Shortcut Description

Alt + Shift + Page Down Extend selection right one screen

Alt + Shift + Page Up Extend selection left one screen

Ctrl + Shift + Down Arrow Extend the selection to the last cell down

Ctrl + Shift + Left Arrow Extend the selection to the last cell left

Ctrl + Shift + Right Arrow Extend the selection to the last cell right

Ctrl + Shift + Up Arrow Extend the selection to the last cell up

Shift + Down Arrow Extend selection by one cell down

Shift + Left Arrow Extend selection by one cell left

Shift + Right Arrow Extend selection by one cell right

Shift + Up Arrow Extend selection by one cell up

File MS Excel Shortcut Keys

Shortcut Description

Alt + F4 Close Excel

Ctrl + F4 Close current workbook

Ctrl + P Print file

Formatting

Shortcut Description

Alt + H,5 Remove indent

Alt + H,6 Indent

Alt + H,A,C Align center

Alt + H,A,L Align left

Alt + H,A,R Align right

Alt + H,FG Increase font size one step

Alt + H,FK Decrease font size one step

Ctrl + 5 Apply or remove strikethrough formatting

Ctrl + B Apply or remove bold formatting

Ctrl + I Apply or remove italic formatting

Ctrl + Shift + F Display Format Cells with Font tab selected

Ctrl + U Apply or remove underscoring

General MS Excel Shortcut Keys

Shortcut Description

Alt + F,T Open options

Ctrl + Alt + V Display the Paste Special dialog box

Ctrl + F Display find and replace

Ctrl + H Display find and replace, replace selected

Ctrl + Shift + F4 Find previous match

Ctrl + V Paste content from clipboard

Ctrl + X Cut selected cells

Ctrl + Y Redo last action

Shift + F4 Find next match

Grid Operations

Shortcut Description

Alt + Shift + Right Arrow Group rows or columns

Ctrl + 8 Hide or show outline symbols

Ctrl + Alt + + Zoom in

Ctrl + Alt + – Zoom out

Delete Delete contents of selected cells

Navigation

Shortcut Description

Ctrl + Left Arrow Move to left edge of data region

Ctrl + Right Arrow Move to right edge of data region

End Turn end mode on

Left Arrow Move one cell left

Right Arrow Move one cell right

Ribbon MS Excel Shortcut Keys

Shortcut Description

Alt Activate access keys

Ctrl + F1 Expand or collapse ribbon

F1 Get help on selected control or Open help

Spacebar Activate or open selected control

Selection

Shortcut Description

Ctrl + Alt + Left Arrow Move left between non-adjacent selections

Ctrl + Alt + Right Arrow Move right between non-adjacent selections

Ctrl + Click Add non-adjacent cells to selection

Shift + Click Add adjacent cells to selection

Tables and Filters

Shortcut Description

Alt + C Clear slicer filter

Alt + Down Arrow Activate filter

Ctrl + Shift + L Toggle Autofilter

Ctrl + Shift + T Toggle table total row

Ctrl + T Insert table

Selecting Cells, Rows and Columns

Shortcut Description

Ctrl + A Select all cells on the current worksheet

Ctrl + Shift + End Extend the selection to the last cell used on the worksheet

Ctrl + Shift + Home Extend the selection to the first cell used on the worksheet

Ctrl + Shift + Spacebar Select all the objects on the current worksheet while retaining the current selection

Ctrl + Spacebar Extend the selection in the direction of the arrow key

F8 Toggle Extend mode on and off

Shift + Page Up Extend the selection upward by one screen

Shift + Backspace Reduce the selection to the active cell

Shift + F8 Toggle add mode on and off

Shift + Home Extend the selection to the first cell in the row

Shift + Page Down Extend the selection downward by one screen

Shift + Spacebar Select the current columns

Applying Borders MS Excel Shortcut Keys

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

Shortcut Description

Alt + B Toggle the bottom border on the selected cells

Alt + D Toggle the downward diagonal border on the selected cells

Alt + H Toggle the horizontal border on the selected cells

Alt + L Toggle the left border on the selected cells

Alt + R Toggle the right border on the selected cells

Alt + T Toggle the top border on the selected cell

Alt + U Toggle the upward diagonal border on the selected cells

Alt + V Toggle the vertical border on the selected cells

Ctrl + Shift + & Apply an outline border

Ctrl + Shift + _ Remove the outline border

Creating and Navigating in Charts

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

F11, Alt + F1 Create a chart from the selected range

Entering and Editing Data

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

Shortcut Description

Alt + Enter Begin a new line within the active cell

Alt + F8 Displays the Macro dialog box to run, edit, or delete a macro

Alt + Page Up Move to the left by one screen

Alt + Shift + F1 Inserts a new worksheet

Backspace Delete from the insertion point to the end of the cell’s contents

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़ Ctrl + 0 Hides the selected columns

Ctrl + 9 Hides the selected rows

Ctrl + : Enters the current time

Ctrl + ; Enters the current date

Ctrl + _ Removes the outline border from the selected cells

Ctrl + A Selects the current region

Ctrl + Backspace Scroll the workbook to display the active cell

Ctrl + C Displays the Microsoft Office Clipboard

Ctrl + Delete Delete from the insertion point to the end of the cell’s contents.

Ctrl + Down Arrow Display the AutoComplete drop-down list

Ctrl + End Move to the last used cell in the worksheet

Ctrl + Enter Fill the selected range with the entry

Ctrl + F10 Restore or maximize the selected minimized workbook window

Ctrl + F3 Display the Define Name dialog box

Ctrl + F5 Restores the window size of the selected workbook window

Ctrl + F9 Minimize the active workbook window

Ctrl + Home Move to the last used cell in the worksheet

Ctrl + O Displays the Open dialog box to open or find a file

Ctrl + R Displays the Print dialog box

Ctrl + S Saves the active file with its current file name and location

Ctrl + Shift + : Enter the time in the active cell

Ctrl + Shift + F3 Display the Create Names dialog box

Ctrl + Shift + O Selects all cells that contain comments

Ctrl + Shift + Z Undo the most recent AutoCorrect

Ctrl + Spacebar Select the current worksheet

Ctrl + Z Repeats the last command or action, if possible

Ctrl+ G Display the Go To dialog box

Enter Enter the entry in the cell and select the next cell

Esc Cancel editing in the active cell

F10 Minimizes a workbook window to an icon

F12 Displays the Save As dialog box

F2 Switch the active cell into Edit mode

F3 Pastes a defined name into a formula

F4 Repeats the last command or action, if possible

F7 Displays the Spelling dialog box to checkspelling in the active worksheet or selected range

F8 Toggle Extend mode on and off

Home Move to the first cell in the active row

Page Down Move down the screen

Page Up Move up the screen

Shift + Enter Enter the entry in the cell and select the next cell in the opposite direction

Shift + F10 Displays the shortcut menu for a selected item

Shift + F11 Inserts a new worksheet

Shift + F2 Insert a new comment or edit the existing comment

Shift + F8 Toggle add mode on and off

Shift + Spacebar Select the current row

Shift + Tab Enter the entry in the cell and select the next cell to the left.

Tab Enter the entry in the cell and select the next cell to the right

Formatting Cells MS Excel Shortcut Keys

Shortcut Description

MS Excel Shortcut Keys

Alt + ‘ Display the Style dialog box

Ctrl + 1 Display the Format Cells dialog box

Ctrl + 5 Toggle strikethrough

Ctrl + Shift + ! Apply the two-decimal-place number format with the thousands separator

Ctrl + Shift + # Apply the DD-MM-YY date format

Ctrl + Shift + $ Apply the two-decimal-place Currency format

Ctrl + Shift + % Apply the Percentage format ( no decimal places)

Ctrl + Shift + @ Apply the HH:MM AM/PM time format

Ctrl + Shift + ^ Apply the Exponential format with two decimal places

Ctrl + Shift + ~ Apply the General format

Hiding and Unhiding Rows and Columns

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

Shortcut Description

Ctrl + 0 Hide all selected columns

Ctrl + 9 Hide all selected rows

Ctrl + Shift + { Unhide hidden rows in the selection

Ctrl + Shift + } Unhide hidden columns in the selection

Inserting and Deleting Cells

Shortcut Description

Ctrl + – Delete the selected cells

Ctrl + Shift + + Insert cells

Minimizing and Navigating Among Workbook

Shortcut Description

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

Alt + Page Down Move to the right by one screen

Alt + Page Up Move to the left by one screen

Ctrl + Backspace Scroll the workbook to display the active cell

Ctrl + End Move to the first cell in the worksheet

Ctrl + F10 Restore or maximize the selected minimized workbook window

Ctrl + F9 Minimize the active workbook window

Ctrl + G Display the Go To dialog box

Ctrl + Home Move to the last used cell in the worksheet

Ctrl + N Create a new default workbook

Ctrl + Page Up Move to the next worksheet

Ctrl + Shift + Page Down Select the current worksheet and the next worksheet

Ctrl + Shift + Tab Select the previous minimized workbook window

Ctrl + Tab Select the next minimized workbook window

Page Down Move down one screen

Page Up Move up one screen

Shift + F11, Alt + Shift + F1 Insert a new worksheet in the active workbook

Recalculating Worksheets and Workbooks

Shortcut Description

Ctrl + Alt + F9 Recalculating all calculations in all the worksheets in all the open workbooks

Ctrl + Alt + Shift + F9 Recheck all formulas, then recalculate all calculation in all the worksheets

F9 Recalculating all the worksheets in all the open workbooks

Shift + F9

Selecting Cells That Match Criteria

Shortcut Description

MS Excel Shortcut Keys

Alt + ; Select only the visible cells in the current selection

Ctrl + / Select the array that the active cell is in

Ctrl + [ Select cells directly referenced by formulas in the active cell.

Ctrl + \ Select non-matching cells in the active row

Ctrl + ] Select cells that contain formulas directly referencing the active cell

Ctrl + Shift + * Select the data region

Ctrl + Shift + 0 Select all cells that have comments attached

Ctrl + Shift + { Select cells directly or indirectly referenced by formulas in the active cell

Ctrl + Shift + | Select non-matching cells in the active column

Ctrl + Shift + } Select cells that contain formulas directly or indirectly referencing the active cell

Working In Data Forms MS Excel Shortcut Keys

Shortcut Description

MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़

Ctrl + Page Down Insert a new, blank record in the database

Down Arrow Move to the next record, same field

Enter Move to the next record, first field

Page Down Move ten records backward, same field

Page Up Move ten records backward, same field

Shift + Enter Move to the next record, first field

Up Arrow Move to the previous record, same field

Working In PivotTables

Shortcut Description

MS Excel Shortcut Keys

Alt + Shift + Left Arrow Group the select items

Ctrl + Shift + * Select the entire Pivot Tables

Working In Print Preview

Shortcut Description

Ctrl + Down Arrow Display the last page of the print area

Ctrl + Up Arrow Display the first page of the print area

Page Down Display the next page

Page Up Display the previous page

Working With Formulas

Shortcut Description

MS Excel Shortcut Keys

= Start creating a formula

Alt + = Insert an AutoSum formula in the active cell

Ctrl + ‘ Copy the formula from the cell above the active cell

Ctrl + A Display the Function Arguments dialog box

Ctrl + Shift + \ Copy the value of the cell above the active cell

Ctrl + Shift + A Enter the argument names in the Formula bar

Ctrl + Shift + Enter Enter the formula as an array formula

Enter Enter the formula in the cell

F3 Displays the Paste Name dialog box

Shift + F3 Display the Insert Function dialog box

MS Excel Shortcut Keys Video

READ: MS Word Shortcut Keys : एमएस वर्ड शॉर्टकट कीज़। 

READ: Java Servlets क्या है जाने हिंदी में।

Conclusion:

तो दोस्तों अगर आपको हमारी MS Excel Shortcut Keys PDF: एमएस एक्सेल शॉर्टकट कीज़ । यह पोस्ट पसंद आई है तो इसको अपने दोस्तों के साथ FACEBOOK पर SHARE कीजिए और WHATSAPP पर भी SHARE कीजिए और आपको ऐसे ही POST और जानकारी चाहिए तो हमें कमेंट में आप लिख कर बता सकते हैं उसके ऊपर हम आपको अलग से एक पोस्ट लिखकर दे देंगे दोस्तों.


HI HINDIYOUTH.COM AAP KO JOBS, ONLINE EARNING, EDUCATION, BUSINESS, INVESTMENT, CAREER TIPS GUIDE DETA HE. HINDI ME TAKI AAP KI THORISI HELP HO SAKE, ME CHAHTA HU KI INDIA KE YUVA KO SAHI KNOWLEDGE MIL SAKE JO UNKE KAAM KA HO.

Leave a Comment

0 Shares
Share
Tweet
Pin
Share