Use belowshortcut key and make excel sheet easy
Alt =AutoSum.
Ctrl-B Bold
Ctrl-Shift _ Border lines off
Ctrl-Shift & Border lines on.
Shift-F9 Calculate active sheet
F9 Calculate all worksheets
Ctrl-W Close
Collapse select to active cell
Shift- Backspace
Comment insert/edit
Shift-F2
Copy
Ctrl-C
Copy formula from cell above
Ctrl '
Copy value from cell above
"Ctrl-Shift """
Cut
Ctrl-X
Date
Ctrl ;
Delete range
Ctrl -
Delete to end of line
Ctrl-Del
Show values/formulas
Ctrl `
Edit cell
F2
Enter formula as array
Ctrl-Shift-Enter
Fill down
Ctrl-D
Fill right
Ctrl-R
Find
Ctrl-F
Format commas (2 dec places)
Ctrl-Shift !
Format currency (2 dec places)
Ctrl-Shift $
Format date (DD, MM, YY)
Ctrl-Shift #
Format exponential number (2 decimal places)
Ctrl-Shift ^
Format general number
Ctrl-Shift ~
Format percentage (0 decimal places)
Ctrl-Shift %
Format time (hour and minute)
Ctrl-Shift @
Formula
=
Function Wizard
Shift-F3
GoTo
Ctrl-G
Group row/column
Alt-Shift-Right
Hard Return in cell
Alt-Enter
Hide selected column(s)
Ctrl-0 (zero)
Hide selected row(s)
Ctrl-9
Insert chart sheet
F11
Insert Function components
Ctrl-Shift-A
Insert range
Ctrl-Shift-Plus
Insert worksheet
Shift-F11
Italics
Ctrl-I
Menu bar
F10
Move between noncontiguous selections Ctrl-Alt-Left/Right
Move left/right one screen
Alt-PgUp/PgDn
Move to beginning of worksheet
Ctrl-Home
Move to edge of region
Ctrl-Arrow
Move to end of row
End, Enter
Move to end of worksheet
Ctrl-End
Move to next corner of selection
Ctrl .
Move up through a selection
Shift-Enter
Name a range (Insert/Name/Create)
Ctrl-Shift-F3
Name a range (Insert/Name/Define)
Ctrl-F3
New
Ctrl-N
Next window
Ctrl-F6
Next worksheet
Ctrl-PgUp
Open
Ctrl-O
Outline symbols display/hide
Ctrl-8
Paste
Ctrl-V
Paste named range (Insert/Name/Paste) F3
Previous window
Ctrl-Shift-F6
Previous worksheet
Ctrl-PgDn
Ctrl-P
Repeat Find
Shift-F4
Repeat/Redo
Ctrl-Y
Replace
Ctrl-H
Save
Ctrl-S
Save As
F12
Scroll to display active cell
Ctrl-Backspace
Select array to which active cell belongs Ctrl /
Select cells directly referred to by selected formula
Ctrl [
Select cells referred to by selected formula Ctrl-Shift {
Select cells with comments
Ctrl-Shift ?
Select column
Ctrl-spacebar
Select current region
Ctrl-Shift *
Select formulas that directly refer to active cell
Ctrl ]
Select formulas that refer to active cell
Ctrl-Shift }
Select objects on worksheet
Ctrl-Shift-spacebar
Select row
Shift-spacebar
Select to beginning of row
Shift-Home
Select to beginning of worksheet
Ctrl-Shift-Home
Select to edge of region
Ctrl-Shift-(Arrow)
Select to end of row
End, Shift-Enter
Select to end of worksheet
Ctrl-Shift-End