How to use keyboard shortcut keys in ms excel yani ki microsoft excel keyboard shortcut key kaise use kare iss post me hum janenge. So agar aap ms excel ka use karte hai aur ms excel spreadsheet me shortcut keys ka use karne ke baare me janana chahte hai to aaj ki ye post aapke liye hi hai.
Ms excel puri duniya me sabse jyada use hone wale spreadsheet program me se ek hai. Data ko organize karne, analyze karne aur reports banane ke liye ye ek powerful tool hai.
Microsoft excel me keyboard shortcuts ka use karke aap apni efficiency ko kai guna tak increase kar sakte hai. Ye ms excel keyboard shortcut na kewal aapka time save karenge balki isse aapko baar baar apna mouse use karne ki jarurat bhi nahi padegi.
Ms excel me keyboard shortcuts ka use karne se aapka kaam kafi jyada fast aur accurate ho jayega. To chaliye iss article me ms excel ke kuch sabse important aur useful keyboard shortcuts ke bare me detail me janate hai.
- Ms Excel me Dropdown List Font Size ko Increase Kaise Kare
- Microsoft Excel me English Name ko Hindi me Convert Kaise Kare
Microsoft Excel Keyboard Shortcut Keys Kaise Use Kare
General & Workbook Shortcuts
Ctrl + N Create a new, blank workbook.
Ctrl + O Open an existing workbook.
Ctrl + P Open the Print dialog box.
Ctrl + S Save the active workbook.
Ctrl + W Close the active workbook.
Ctrl + Y Redo the last action.
Ctrl + Z Undo the last action.
F7 Perform a spelling check.
F12 [Save As] to save a workbook with a new name or location.
Navigation Shortcuts
Ctrl + Arrow Keys Move to the edge of the current data region in that direction.
Ctrl + End Go to the last cell on the worksheet that contains data or formatting.
Ctrl + G or F5 Open the “Go To” dialog box.
Ctrl + Home Go to cell A1.
Ctrl + Page Down Move to the next worksheet in the workbook.
Ctrl + Page Up Move to the previous worksheet in the workbook.
Enter Move one cell down.
Shift + Enter Move one cell up.
Shift + Tab Move one cell to the left.
Tab Move one cell to the right.
Arrow Keys Move one cell up, down, left, or right.
Formatting Shortcuts
Ctrl + 1 Open the “Format Cells” dialog box, which gives you access to all formatting options.
Ctrl + 5 Apply or remove strikethrough.
Ctrl + B Apply or remove bold formatting.
Ctrl + I Apply or remove italic formatting.
Ctrl + Shift + ! Apply the Number format with two decimal places and a thousands separator.
Ctrl + Shift + # Apply the Date format.
Ctrl + Shift + $ Apply the Currency format.
Ctrl + Shift + % Apply the Percentage format.
Ctrl + Shift + & Apply an outline border to the selected cells.
Ctrl + Shift + @ Apply the Time format.
Ctrl + Shift + _ Remove the outline border from the selected cells.
Ctrl + Shift + ~ Apply the General number format.
Ctrl + U Apply or remove underline formatting.
Alt + H, B Add borders to selected cells.
Alt + H, H Choose a fill color for the cell.
Row & Column Shortcuts
Ctrl + – Open the “Delete” dialog box to delete cells, rows, or columns.
Ctrl + 0 Hide the selected columns.
Ctrl + 9 Hide the selected rows.
Ctrl + Shift + + Open the “Insert” dialog box to insert cells, rows, or columns.
Ctrl + Shift + 0 Unhide the selected columns.
Ctrl + Shift + 9 Unhide the selected rows.
Selection Shortcuts
Ctrl + A Select the entire worksheet. If you are in a data set, the first press selects the current data region; a second press selects the entire sheet.
Ctrl + Shift + Arrow Keys Extend the selection to the edge of the current data region.
Ctrl + Spacebar Select the entire column.
Shift + Arrow Keys Extend the selection by one cell.
Shift + Spacebar Select the entire row.
Data Entry & Editing Shortcuts
Ctrl + ; Enter the current date.
Ctrl + Alt + V Open the “Paste Special” dialog box, which gives you more control over what you paste.
Ctrl + C Copy the selected cells.
Ctrl + D “Fill Down” – Copy the contents and format of the topmost cell in the selected range into the cells below.
Ctrl + F Open the “Find” dialog box.
Ctrl + H Open the “Find and Replace” dialog box.
Ctrl + R “Fill Right” – Copy the contents and format of the leftmost cell in the selected range into the cells to the right.
Ctrl + Shift + : Enter the current time.
Ctrl + V Paste the copied or cut cells.
Ctrl + X Cut the selected cells.
F2 Edit the active cell, placing the cursor at the end of the cell’s contents.
Alt + = Insert a SUM formula for the adjacent numbers.
I hope, aap microsoft excel ki keyboard shortcut keys ko use karne ke bare me acche se samajh gaye honge, agar aapko ye jankari helpful lagi ho to ise apne friends ke sath bhi share kare.