Excel Shortcuts

 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 + W  = Close

 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

Post a Comment

0 Comments