Shortcut keys excel

hort cut keys are the easiest and shortest way to finish your files or documents in MS Excel or other Programs. Wish you use these short cut keys in MS Excel and commit them all to memory to be a good and a fast computer operator.

Ctrl + 9=    Hide Rows

Ctrl + 0=    Hide Columns

Ctrl + F4 + =    Closes Work Book Window

Ctrl + F10=    Maximize the Work Book

Ctrl + F9= Minimize the Work Book

Ctrl + F5= Restore Window Size

Ctrl + F6= Next Window

Ctrl + Tab=    Next Window

Ctrl + F11=    Insert a New Sheet

Ctrl + P= Print

Ctrl + S= Saves the Work Book

Ctrl + O= Open a Work Book

Ctrl + 1= Format Dialog Box

Ctrl + N= Create a New Work Book

Ctrl + H= Find and Replace

Ctrl + K= Insert Hyperlink

Ctrl + W= Closes the Work Book

Ctrl + A= Select the Entire Worksheet

Ctrl + X/C/V= Cut/Copy/Paste

Ctrl + 7 = Show or hide the standard toolbar

Ctrl + Tab= Switch Between Open Excel Files

Ctrl + Space= Select the Entire Column

Ctrl + Shift + $ =General Num, Format   

Ctrl + Shift + S =Currency Format

Ctrl + Shift + %= Percentage Format

Ctrl + Shift +! = Comma Format

Ctrl + Shift + &=Outline Border   

Ctrl + Shift + __=Remove Borders

Ctrl + Shift +9=Unhide Rows

Ctrl + Shift +0=Unhide Columns

Ctrl + Page Up/Down =Go to Previews/Next Worksheet

Ctrl +Home/End= Go to First/Last Cell of the Worksheet

Ctrl + Arrow Key= Go to the Next(Last) Empty Cell

Shift + Space= Select the Entire Rows

Shift + F3= Insert Function

Shift +F2= Insert Comments

Shift + F10= In place of Right click of Mouse

Shift + Arrow Key=Extent the selection by one cell

Shift + Enter= Leads the Curser Upward

F11= Insert a New Sheet

F12= Saves as

F5= Go to

F7= Spell Checking

Alt + 0149= .

Alt + 0163= £

Alt + 0153= T

Alt + 0169= ©

Alt + 0188= ¼

Alt + 0189 ½

Alt + 0190= ¾

Alt + 0165= ¥

Alt + 0133

Alt + 0191= ¿

Alt + 254= ■

Alt + 8= ◘

Alt + 888= x

Alt + 16=

Alt + 17= ◄

Alt + 30= ▲

Alt + 31= ▼

Alt + E= Edit

Alt + F= File (Format)

Alt +V= View

Alt + I= Insert

Alt + T= Tools(Table)

Alt + W= Window

Alt + H= Help

Alt + F8= Macros Dialog Box

Alt + F11= Visual Basic Editor

Alt + Enter Insert a New Work Book

Alt + Tab= Switch Between Applications

Alt + F4= Close Excel

Alt + ' = Display the new style dialog box

Alt + Click= Search (Treasury)