Excel Shortcuts

Now days, excel is very widely used in all over the world, so here some important excel shortcuts mentioned so carefully read it and try it to do practice.
There are few specific keys are organized in specific manners, they are as mentioned below:-
- Alphanumeric Keys :- These keys include same letter, number, punctuation, and symbol keys found on a traditional keyboards.
- Control Keys :- These keys are used alone or in combination with other keys to perform certain actions. The most frequently used control keys are Ctrl, Alt, the Windows logo key, and Esc.
- Function Key :- The function keys are used to perform specific tasks. They are labeled as F1 to F12.
- Navigation Keys :- These keys are used to moving around in documents or webpages and editing text. they are arrow keys, home, end, page up, page down, delete, and insert.
- Numeric Keys :- The numeric keypad is handy for entering numbers quickly. The keys are grouped together in a block like a conventional calculator or adding machine.


F1 - HELP
F1 is mostly used as the help key. Almost every program will open the help screen when this key is pressed. Window key + F1 would open the Microsoft windows help and support center. Opens the Task Pane.
F2 - EDIT
In windows commonly used to rename a highlighted icon or file.
F3 - PASTE NAME
Often opens a search feature for many programs including Microsoft windows.
F4 - REPEAT LAST ACTION
WHILE TYPING A FORMULA, SWITCH BETWEEN ABSOLUTE/RELATIVE REFS
F5 - GO TO
Pressing F5 will refresh or reload the page or document window - This can be a handy shortcut. Open the find, replace, and go to window in Microsoft word. Starts a slideshow in PowerPoint.
F6 - NEXT PANE
This key is often used to move the cursor to the Address bar Mozilla, Firefox or Internet Explorer.
F7 - SPELL AND GRAMMAR CHECK
Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft word, Outlook, etc.
F8 - OPEN THE BOOT MENU IN WINDOWS, EXTEND MODE
The F8 key can be used to access Safe Mode if pressed during the computer's boot up process.
F9 - TO REFRESH MICROSOFT WORD DOCUMENT.
RECEIVES EMAILS IN OUTLOOK, RECALCULATE ALL WORKBOOKS.
F10 - OPEN A MENU BAR
This key used to activate the menu bar is many programs. F10 can be used to highlight the first menu choice, and then use to arrow keys to move around the menus.
F11 - ENTERS AND EXITS THE FULL-SCREEN MODE IN INTERNET BROWSER, NEW CHART.
Full-screen mode in all modern internet browsers-pressing F11 when you are working in internet explorer will open the windows to full-screen mode.
F12 - IN MICROSOFT WORDS, OPENS THE SAVE AS DIALOGUE BOX.
Open a new document in Microsoft Word.
Ctrl + A = Select All
Ctrl + B = Bold
Ctrl + C = Copy
Ctrl + D = Fill Down
Ctrl + E = Flash Fill
Ctrl + F = Find
Ctrl + G = Goto
Ctrl + H = Replace
Ctrl + I = Italic
Ctrl + K = Insert Hyperlink
Ctrl + N = New Workbook
Ctrl + O = Open
Ctrl + P = Print
Ctrl + R = Fill Right
Ctrl + S = Save
Ctrl + U = Underline
Ctrl + V = Paste
Ctrl + X = Cut
Ctrl + Y = Repeat
Ctrl + Z = Undo
Ctrl + : = Insert Current Time
Ctrl + ; = Insert Current Date
Ctrl + '' = Copy Value from Cell Above
Ctrl + ' = Copy Formula from Cell Above
Ctrl + Alt + F9 = Calculate all worksheet in all open workbooks, regardless of weather they have changed since the last calculation.
Ctrl + Alt + Shift + F9 = Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Ctrl + F3 = Define Name
Ctrl + F4 = Close
Ctrl + F5 = XL, Restore window size
Ctrl + F6 = Next workbook window
Ctrl + F7 = Move window
Ctrl + F8 = Resize window
Ctrl + F9 = Minimize workbook
Crtl + F10 = Maximize or restore window
Ctrl + F11 = Insert 4.0 Macro sheet
Ctrl + F12 = File Open
Ctrl + Shift + F3 = Create name by using names of row and column labels
Ctrl + Shift + F6 = Previous Window
Ctrl + Shift + F12 = Print
Ctrl + ` = Toggle Value / Formula display
Ctrl + Shift + A = Insert argument names into formula
Ctrl + Shift + ~ = General format
Ctrl + Shift + ! = Comma format
Ctrl + Shift + @ = Time Format
Ctrl + Shift + # = Date Format
Ctrl + Shift + $ = Currency format
Ctrl + Shift + % = Percentage format
Ctrl + Shift + & = Place outline border around selected cells
Ctrl + Shift + _ = Remove outline border
Ctrl + Shift + * = Select the current region around the active cell. In a PivotTable report, select the entire Pivot Table report
Ctrl + (+) = Insert
Ctrl + (-) = Delete
Ctrl + 1 = Format cells dialog box
Ctrl + 2 = Bold
Ctrl + 3 = Italic
Ctrl + 4 = Underline
Ctrl + 5 = Strikethrough
Ctrl + 6 = Show / Hide Objects
Ctrl + 7 = Show / Hide Standard toolbar
Ctrl + 8 = Toggle outline symbols
Ctrl + 9 = Hide rows
Ctrl + 0 = Hide columns
Ctrl + Shift + ) = Unhide columns
Ctrl + Tab = In toolbar : next toolbar, In workbook : activate next workbook
Ctrl + Enter = Fill the selected cell range with the current entry
Ctrl + Space bar = Select the entire column
Ctrl + Backspace = Jump back to the active cell and bring it into view.
Ctrl + / = Select the array containing the active cell.
Ctrl + Shift + o = Select all cells that contain comments.
Ctrl + \ = In a selected row, selected the cells that don't match the formula or static value in the active cell
Ctrl + Shift + | = In a selected column, select the cells that don't match the formula or static value in the active cell
Ctrl + [ = Select all cells directly referenced by formulas in the selection.
Ctrl + Shift + { = Select all cells directly or indirectly referenced by formulas in the selection
Ctrl + ] = Select cells that contain formulas that directly reference the active cell
Ctrl + Shift + } = Select cells that contain formulas that directly or indirectly reference the active cell
Ctrl + Alt + L = Reapply the filter and sort on the current range so that changes you've made are included
Ctrl + Alt + V = Displays the paste special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program

Shift = Hold down shift for additional functions in excels menu
Shift + F1 = What's This? (help)
Shift + F2 = Edit cell comment
Shift + F3 = Paste function into formula
Shift + F4 = Find Next
Shift + F5 = Find
Shift + F6 = Previous Pane
Shift + F8 = Add to selection
Shift + F9 = Calculate active worksheet
Shift + F10 = Display shortcut menu
Shift + F11 = New Worksheet
Shift + F12 = Save
Shift + Ctrl + F6 = Previous workbook window
Shift + Ctrl + Tab = In toolbar: previous toolbar, In a workbook: activate
Shift + Tab = Previous tool
Shift + Ctrl + F = Font Drop Down List
Shift + Ctrl + P = Point size Drop Down List
Shift + Spacebar = Select the entire row
Shift + Backspace = With multiple cells selected, select only the active cell
Alt + F1 = Insert Chart
Alt + F2 = Save As
Alt + F4 = Exit
Alt + F8 = Macro dialog box
Alt + F11 = Visual Basic Editor
Alt + Shift + F1 = New worksheet
Alt + Shift + F2 = Save
Alt + = = Autosum
Alt + Down Arrow = Display Autocomplete list
Alt + ' = Format Style dialog box
Alt + Enter = Start a new line in the same cell.
Alt + ; = Select the visible cells in the current selection
Tab = Next tool
Enter = Do the command
0 Comments