Microsoft Excel Keyboard Shortcuts

clip_image001[4]

Now, these days excel shortcuts is necessary for maintain day to day reports. So, we are sharing with you the basic excel shortcuts with you.

General Program Shortcuts

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks

Open Excel using Run

Open Run > Type Excel then enter. It will open excel sheet.

clip_image002[4]
Command’sDescriptions
Alt or F10 Turnkey tips on or off
Alt+ F4         Close Excel
Alt+A Go to the Data tab
Alt+Enter Insert a hard return within a cell (while editing a cell)
Alt+F Open the File tab menu
Alt+F1 Create an embedded bar chart based on select data (same sheet)
Alt+F11 Open the Microsoft Visual Basic For Applications Editor
Alt+F8 Create, run, edit, or delete a macro
Alt+H Go to the Home tab
Alt+H+B Add a border
Alt+H+D+C Delete column
Alt+H+H Select a fill color
Alt+M Go to the Formulas tab
Alt+N Open the Insert tab
Alt+P Go to the Page Layout tab
Alt+Page Up/Down Move one screen to the right or left in a worksheet
Alt+Q 
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+0 Hide the selected columns
Ctrl+1 Open the Format Cells dialog box
Ctrl+5 Apply or remove strikethrough
Ctrl+9 Hide the selected rows
Ctrl+Alt+V Open the Paste Special dialog box
Ctrl+B Add or remove bold to the 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+End Go to the most bottom right used cell
Ctrl+F Search in a spreadsheet, or use Find and Replace
Ctrl+F1 Show or hide the ribbon
Ctrl+F11 Insert a new Excel Macro sheet
Ctrl+F2 Open Print Preview
Ctrl+F4         Close Excel sheet
Ctrl+F9 Minimize the workbook window
Ctrl+Home Move to the beginning of a worksheet
Ctrl+I Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+Left/Right Arrow Move to the farthest cell left or right in the row
Ctrl+N         Create a new Excel
Ctrl+O         Open an older workbook
Ctrl+Page Up/Down Move to the previous or next worksheet
Ctrl+S         Save Excel workbook
Ctrl+Shift+$ Apply currency format
Ctrl+Shift+% Apply percent format
Ctrl+Shift+& Apply outline border
Ctrl+Shift+_ (Underline) Remove outline border
Ctrl+Shift+Space Select the entire worksheet
Ctrl+Shift+U Expand or collapse the formula bar
Ctrl+Space Select the entire column
Ctrl+Tab Switch between open workbooks
Ctrl+U Add or remove underline to the contents of a cell, selected data, or selected cell range
Ctrl+Up/Down Arrow Move to the top or bottom cell in the column
Ctrl+V or Shift+Insert Paste contents of a cell, selected data, or selected cell range
Ctrl+W         Close a Excel sheet
Ctrl+X Cut contents of a cell, selected data, or selected cell range
Ctrl+Y Redo an action
Ctrl+Z Undo an action
Delete Remove the contents of a cell, selected data, or selected cell range
Enter Complete an entry in a cell or the formula bar
Esc Cancel an entry in a cell or the formula bar
F1 Open the Help page
F11 Create a bar chart based on selected data (on a separate sheet)
F12         Open the Save As dialog box
F2 Edit a cell
F3 Paste a cell name (if cells are named in the worksheet)
F5 Go to any cell by pressing F5 and typing the cell coordinate or cell name.
F7 Check spelling
F9 Calculate all worksheets in all Open workbooks
Home Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Left/Right Arrow Move one cell to the left or right
Page Up/Down Move one screen up or down in a worksheet
Shift+F11Insert a new Excel worksheet in existing Excel
Shift+F2 Add or edit a cell comment
Shift+F3 Insert a function
Shift+F9 Calculate active worksheets
Shift+Left/Right Arrow Extend the cell selection to the left or right
Shift+Space Select the entire row
Shift+Tab Go to the previous cell
Tab Go to the next cell
Up/Down Arrow Move one cell up or down

Practice more on keyboard make you learn quickly.
Click to rate this post!
[Total: 1 Average: 5]

Share and Enjoy !

Shares
Get Weekly KBV Tips !

Learn and improve day to day Knowledge & lifestyles.