Latest Qualification Jobs

Best Microsoft Excel Keyboard Shortcuts | परीक्षा में पूछे जाने वाले/Imp

Excel Shortcut Keys

Microsoft Excel is a very important tool, which helps us a lot in everyday life. In Excel we can make tables, keep track of anything and even make school projects etc. Excel has a lot of features and it becomes quite difficult and difficult to use these features. There are some Excel Shortcut Keys that help you to make your work easier. Here, We have presented Best Microsoft Excel Keyboard Shortcuts on this page. You can check परीक्षा में पूछे जाने वाले Important Excel Shortcut Keys from below.

recruitmentresult.com

Today I will tell you some keyboard shortcuts of Microsoft Excel, with the help of which you can work faster. If someone wants to do fast work, then today’s post will prove very useful for you. let’s see these Best Microsoft Excel Keyboard Shortcuts, due to which you will be able to work in Microsoft Excel quickly.

Excel Shortcut Keys

General Program Shortcuts

ShortcutUsage
Ctrl+N Create a new workbook
Ctrl+O Open an existing workbook
Ctrl+S Save a workbook
F12 Open the Save As dialog box
Ctrl+W Close a workbook
Ctrl+F4 Close Excel
F4 Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
Shift+F11Insert a new worksheet
Ctrl+Z Undo an action
Ctrl+Y Redo an action
Ctrl+F2Switch to Print Preview
F1 Open the Help pane
Alt+Q Go to the “Tell me what you want to do” box
F7 Check spelling
F9 Calculate all worksheets in all open workbooks
Shift+F9Calculate active worksheets
Alt or F10 Turn key tips on or off
Ctrl+F1 Show or hide the ribbon
Ctrl+Shift+U Expand or collapse the formula bar
Ctrl+F9Minimize the workbook window
F11 Create a bar chart based on selected data (on a separate sheet)
Alt+F1Create an embedded bar chart based on select data (same sheet)
Ctrl+F Search in a spreadsheet, or use Find and Replace
Alt+FOpen the File tab menu
Alt+HGo to the Home tab
Alt+N Open the Insert tab
Alt+P Go to the Page Layout tab
Alt+M Go to the Formulas tab
Alt+A Go to the Data tab
Alt+RGo to the Review tab
Alt+W Go to the View tab
Alt+X Go to the Add-ins tab
Alt+Y Go to the Help tab
Ctrl+Tab Switch between open workbooks
Shift+F3 Insert a function
Alt+F8 Create, run, edit, or delete a macro
Alt+F11 Open the Microsoft Visual Basic For Applications Editor

 Moving Around in a Worksheet or Cell

ShortcutUsage
Left/Right Arrow Move one cell to the left or right
Ctrl+Left/Right ArrowMove to the farthest cell left or right in the row
Up/Down Arrow Move one cell up or down
Ctrl+Up/Down Arrow Move to the top or bottom cell in the column
Tab Go to the next cell
Shift+Tab Go to the previous cell
Ctrl+End Go to the most bottom right used cell
F5 Go to any cell by pressing F5 and typing the cell coordinate or cell name.
Home Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Ctrl+Home Move to the beginning of a worksheet
Page Up/Down Move one screen up or down in a worksheet
Alt+Page Up/Down Move one screen to the right or left in a worksheet
Ctrl+Page Up/DownMove to the previous or next worksheet

 Read Here: How To Prepare For Online Exam

Selecting Cells

ShortcutUsage
Shift+Left/Right Arrow Extend the cell selection to the left or right
Shift+Space Select the entire row
Ctrl+Space Select the entire column
Ctrl+Shift+Space Select the entire worksheet

Editing Cells

ShortcutUsage
F2 Edit a cell
Shift+F2 Add or edit a cell comment
Ctrl+X Cut contents of a cell, selected data, or selected cell range
Ctrl+C or Ctrl+Insert Copy contents of a cell, selected data, or selected cell range
Ctrl+V or Shift+Insert Paste contents of a cell, selected data, or selected cell range
Ctrl+Alt+VOpen the Paste Special dialog box
DeleteRemove the contents of a cell, selected data, or selected cell range
Alt+Enter Insert a hard return within a cell (while editing a cell)
F3Paste a cell name (if cells are named in the worksheet)
Alt+H+D+CDelete column
Esc Cancel an entry in a cell or the formula bar
Enter Complete an entry in a cell or the formula bar

 Must Know: Best Study Apps for Students

Formatting Cells

ShortcutUsage
Ctrl+B Add or remove bold to the contents of a cell, selected data, or selected cell range
Ctrl+I Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+U Add or remove underline to the contents of a cell, selected data, or selected cell range
Alt+H+H Select a fill color
Alt+H+B Add a border
Ctrl+Shift+&Apply outline border
Ctrl+Shift+_ (Underline) Remove outline border
Ctrl+9 Hide the selected rows
Ctrl+0 Hide the selected columns
Ctrl+1 Open the Format Cells dialog box
Ctrl+5 Apply or remove strikethrough
Ctrl+Shift+$ Apply currency format
Ctrl+Shift+% Apply percent format

Shortcut keys for Microsoft Excel are also mentioned above in detail, we can use these shortcut keys for preparing competitive exams. On this page, the shortcut keys asked in basic exams are described. Nowadays, everyone uses Microsoft Excel for office or personal work, but not everyone will know that with the help of shortcut keys in MS Office Excel, you can work easily and fast.

Candidates can start preparation for competitive exam by using above given MS Excel Shortcut Keys and increase their chances to crack the exam. For more details about Excel Shortcut Keys, candidates can visit our portal (recruitmentresult.com) regularly or also bookmark our site by pressing Ctrl+D key.

Something That You Should Put an Eye On

Person in news Current AffairsGK Current Affairs
All Defence Current AffairsPublic Holidays in India
Current Affairs New AppointmentsInternational Current Affairs
Science & TechnologySports Current Affairs

Filed in: Articles

Leave a Reply

Submit Comment

© 8618 Recruitment, Syllabus, Result, Admit Card. All rights reserved.