Microsoft Excel Shortcut keys that will make your work fast

10/15/2020
by Jaison Chacko Mathew
Microsoft Excel Shortcut keys that will make your work fast

Microsoft excel shortcut keys will make your work much easy and faster. It is time saving. We all know a common software which is used to analyse data and make decisions in many organizations or companies in current world is Microsoft Excel. Not only limited to that, it has vast area of usage in world. Most users have a question can i download Microsoft excel for free? Yes, you can try it for free. Check from Microsoft page. It also has Microsoft excel online facility. You can try this also Microsoft excel download free full version here.

If you are a frequent excel user I do not have to explain you about the usefulness of shortcut keys in excel. A new comer for excel may ask will it save our time? Yes, but you have to practice it more.

When we are dealing with large amount of data it is very helpful to practice shortcut keys. At start some may feel hard to memorize different combinations of ctrl, alt, shift and other keys. But, as per your requirement and your job it will become much easier and time saver.

I recommend you to select frequent keys and make a hard copy. Displaying it somewhere in front of your working table will make life easy. Start using these by referring to that printed copies and by time you will realize you are becoming a excel master.

Microsoft excel shortcut keys

I am going to list down the keys and their functions which may require frequently…

  • Following functions are frequently needed in excel works,
    • Ctrl+Z: Undo an action
    • Ctrl+Y: Redo an action
    • F7: Check spelling
    • Ctrl+S: Save a workbook
    • Ctrl+F2: Switch to Print Preview
    • Ctrl+F9: Minimize the workbook window
    • Ctrl+F: Search in a spreadsheet, or use Find and Replace
  • Following functions are often used but, not less,
    • Ctrl+N: Create a new workbook
    • Ctrl+O: Open an existing workbook
    • F12: Open the Save As dialog box
    • Ctrl+W: Close a workbook
    • Ctrl+F4: Close Excel
    • F4: Repeat the last command or action. Ex; If you apply a font change, this will repeat same action to other selections as well.
    • Shift+F11: Insert a new worksheet
    • F1: Open the Help pane
    • Alt+Q: Go to the “Tell me what you want to do” box
    • F9: Calculate all worksheets in all open workbooks
    • Shift+F9: Calculate 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
    • F11: Create a bar chart based on selected data (on a separate sheet)
    • Alt+F1: Create an embedded bar chart based on select data (same sheet)
    • Alt+F: Open the File tab menu
    • Alt+H: Go 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+R: Go 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
  • Following list of keys also has usages in different applications in excel, Useful when Working with sheets and cells
    • Up/Down Arrow: Move one cell up or down
    • Left/Right Arrow: Move one cell to the left or right
    • Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
    • Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
    • Tab: Go to the next cell
    • Alt+Page Up/Down: Move one screen to the right or left in a worksheet
    • Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
    • Ctrl+End: Go to the most bottom right used cell
    • Shift+Tab: Go to the previous cell
    • Ctrl+Home: Move to the beginning of a worksheet
    • Page Up/Down: Move one screen up or down in a worksheet
    • Ctrl+Page Up/Down: Move to the previous or next worksheet
    • F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
    • 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
    • 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
  • 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+V: Open the Paste Special dialog box
  • Delete: Remove the contents of a cell, selected data, or selected cell range
  • Alt+Enter: Insert a hard return within a cell (while editing a cell)
  • F3: Paste a cell name (if cells are named in the worksheet)
  • Alt+H+D+C: Delete column
  • Esc: Cancel an entry in a cell or the formula bar
  • Enter: Complete an entry in a cell or the formula bar

By starting using these keys regularly you will get improved yourself withing couple of weeks. We will regularly update contents which you need more. 

For any suggestions and improvements in these articles feel free to contact us.

Content Courtesy : https://rizqan.com/microsoft-e...

Comments

No posts found

Write a review