Using Shortcuts in Microsoft Excel 2003 for Data Entry

I am sharing some keyboard shortcuts that will help you in entering data in Microsoft Excel 2003 quickly, that would be helpful in your day to day routine tasks.


Data Entry Shortcuts


> > Start a new line in the same cell

> > ALT ENTER


> > Enter Array Formula

> > CTRL SHIFT ENTER


> > Display the Formula Palette

> > CTRL A


> > Insert Function arguments

> > CTRL SHIFT A


> > Insert a hyperlink

> > CTRL K


> > Edit the active cell

> > F2


> > Paste Function

> > SHIFT F3


> > Calculate all workbooks

> > F9


> > Calculate active workbook

> > CTRL ALT F9



> > Calculate active worksheet

> > SHIFT F9



> > Start a formula

> > =



> > Insert AutoSum formula

> > ALT =



> > Enter date

> > CTRL ;



> > Enter time

> > CTRL SHIFT :



> > Cancel Data Entry

> > ESC



> > Fill down

> > CTRL D



> > Fill to the right

> > CTRL R



> > Fill range with current entry

> > CTRL ENTER



> > Copy

> > CTRL C



> > Copy formatting

> > CTRL SHIFT C



> > Copy value from cell above

> > CTRL SHIFT "



> > Paste Once

> > ENTER

> >

> > Paste Multiple Times

> > CTRL V



> > Paste formatting only

> > CTRL SHIFT V



> > Cut

> > CTRL X



> > Clear cell Contents

> > DELETE



> > Delete Selection

> > CTRL HYPHEN


> > Insert Blank Cells

> > CTRL SHIFT +



> > Edit a cell comment

> > SHIFT F2



> > Paste Range Names

> > F3



> > Create Range Names

> > CTRL SHIFT F3



> > Define Range Name

> > CTRL F3



> > Delete selection

> > BACKSPACE or DELETE



> > Delete text to the end of the line

> > CTRL DELETE



> > Redo

> > ALT SHIFT BACKSPACE



> > Repeat Last Command

> > F4



> > Insert a new worksheet

> > SHIFT F11


> > Create a chart using selected range

> > F11



> > Group sheets

> > SHIFT CTRL PG DN or PG UP



> > Undo

> > CTRL Z