Excel Short Keys

Microsoft Excel short keys File ( Menu ) Keys CTRL+O CTRL+N And ALT+FN CTRL+W CTRL+S ALT+FA ALT+FG ALT+FU CTRL+P ALT+FT ALT+FD ALT+FV ALT+FI ALT+FX Insert Keys ALT+IE ALT+IC ALT+IR ALT+IW ALT+IH ALT+IB ALT+IF ALT+IM ALT+IP ALT+IO CTRL+K

Data Keys ALT+DS ALT+DF ALT+DO ALT+DB ALT+DL ALT+DT ALT+DE ALT+DN ALT+DG ALT+DP ALT+DD ALT+DR

File Open New File Sheet Closed Save Save as Save as web Page Page set up Print Set Print area Send to Print Preview Properties Exit

Cell Columns Row Worksheet Chart Page Break Function Comment Picture Object Hyperlink

Data sort Data filter Form Subtotals Validation Table Columns Consolidate Group Pivot Table Get External data Refresh

Edit Keys CTRL+Z CTRL+Y CTRL+X CTRL+V CTRL+C ALT+ES ALT+ED ALT+EL ALT+EM CTRL+F CTRL+H CTRL+G

Formula Sheet'!A1

Undo Redo Cut Paste Copy Paste Special Entry Delete Sheet Delete Move or copy Find Replace Go TO

Format Keys ALT+OE ALT+OR ALT+OC ALT+OHH ALT+OHU ALT+OHB ALT+OA ALT+OD ALT+OS ALT+OCH ALT+OCA ALT+OCU ALT+OHR

Formet Cell Row Column Sheet Hide Unhide Background Auto Format Conditional Formatting Style Hide Auto fit Unhide Sheat Rename

Window Keys ALT+WN ALT+WA ALT+WD ALT+WU ALT+WS ALT+WF

New window Arrange Hide Unhide Split Freeze panes

View Keys ALT+VN ALT+VP ALT+VT ALT+VF ALT+VS ALT+VH ALT+VC ALT+VC ALT+VV ALT+VF ALT+VZ

Normal Page Break Tool bar Formula bar Status bar Header and Footer Comments Reviewving Custom views Full Screen Zoom

Tool Keys ALT+TS ALT+TA ALT+TH ALT+TT ALT+TW ALT+TP ALT+TO ALT+TG ALT+TE ALT+TU ALT+TMM ALT+TI ALT+TO

Spelling check Auto Correct Share Workbook Track Changes Merge Workbook Protection Online collaboration Goal Seek Scenarios Auditing Macro Add ins Options

Microsoft excel S.No Formula

Result

Formula Method

short keys.'!A1 Use

1 2

=Today() =Now()

11/21/2008 11/21/2008 1:55

Use For Current date Use For Current date&time

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

=Concatenate( Upper Lower =len =vlookup( =count( =Trim( =Fact( =Count Blank( =Count a =Even =odd =Roman( =Hlookup( Pivet Table

3/16/2006 3/16/2006 13:57 Today Date 38792 Deepak DEEPAK 4 DEEPAK Select Coloum A DEEPAK Sharma Factorial

=Today()3977338792 DEEPAK deepak 4 DEEPAK 34 DEEPAK Sharma 120 6 3 6 7 XII 1

Mostly Use for Letters Change Alphabet small to capital Change Alphabet capital to small Use for word count Use For data Sorting Count no of entrys in a row or coloumn It will take only one word space Function It will Count only Blank Space It Will Can Not Count Balnk Cells

5 6 12

Both of Use For Check or for Change Status Use for roman Counting Use Horizently rows only

Please Read ( Coloumn D )Formula Method Carefully. All Formulas Description Contain in this Row

Short Keys S.No 1 2 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

Keys F2 F3 F4 F5 F7 F8 F11 F12 Ctrl+: Ctrl+shift+: Ctrl+B Ctrl+I Ctrl+U ALT+Space+X ALT+Space+R ALT+Space+N Shift+Del

3/17/2006 10:38 AM

Use Editing Print Area Recommand Go to Speling Check Selection Creat Chart Save As Use For Date Use For Time Bold Italic Underline Maximize Restore Minimize Cut

short keys.'!A1

Example 720

720