Formatting Shortcut Keys in Excel 2010

Formatting Shortcut Keys

SHORTCUT_KEYS____	DESCRIPTION______________________________________
Ctrl + B	Apply bold formatting on selected contents
Ctrl + I	Apply italic formatting on selected contents
Ctrl + U	Apply underline formatting on selected contents
Ctrl + 5	Apply/remove strike-through formatting on selected contents
Ctrl + 1	Open Format Cells dialog box
Alt  + ‘	Open Style dialog box
Ctrl + Shft + ~	Apply General Format on selected range
Ctrl + Shft + $	Apply Currency format on selected range
Ctrl + Shft + %	Apply Percentage format on selected range (#,###%)
Ctrl + Shft + #	Apply Date format on selected range (dd-mmm-yy)
Ctrl + Shft + @	Apply Time format on selected range (h:mm:ss AM/PM)
Ctrl + Shft + !	Apply Number format on selected range (#,###.00)
Ctrl + Shft + &	Apply outline-border on selected range
Ctrl + Shft + _	Remove cell borders from selected range
Alt + H + B + A	Apply cell border to all selected cells.

for more information, check below link:

Support.Office.Com

Repeat Last Command Used (Shortkey)

Repeat last command used by pressing <F4> key.

Shortkeys to work around in Excel Environment (Shortkeys/HotKeys)

Important short keys to work around in Microsoft Excel Environment to speedup your productivity ...  

KEYS------------------------	Description-------------------------------------------
Selection
Ctrl + A	Select All (if...)
Shft + ArrowKeys	Select adjacent cell
Shft + SpaceBar	Select whole row
Ctrl + SpaceBar	Select whole column
Column/ Rows/ Cells
Alt O C W	To change column width by points
Alt O R E	To change row height by points
Alt O C A	AutoFit column width as selected cell’s data.
Alt I R	Insert above a blank row
Alt I C	Insert right-side a blank column
Ctrl +	Insert column/ Row/ Cell.
Ctrl –	Delete column/ Row/ Cell.
Ctrl 0	Hide column(s)
Ctrl 9	Hide row(s)
Alt O C U	Unhide columns within selected range
Alt O R U	Unhide rows within selected range
Alt W F F	Toggle Freeze/ Unfreeze rows/columns
Sheets
Ctrl PgUp	Goto previous sheet
Ctrl PgDn	Goto next sheet
Shft F11	Insert new worksheet
Alt H O R	Rename active sheet
Alt T P P	Toggle Protect/ Unprotect sheet
Alt I B	Toggle page break
Alt H O M	To get “Copy and Move” dialogue box
While Cell Editing
Home	Goto start of line
Ctrl Home	Goto Start of cell contents
End	Goto end of line
Ctrl End	Goto end of cell contents
Ctrl LeftArrow	Move one word left side
Ctrl RigthArrow	Move one word right side
Ctrl Delete	To delete all data right side of cursor in cell.

Add or Delete Cell Borders (Shortkeys)

Shortkeys to add or remove a cell or range of cells borders

Ctrl + H + B + S ... Border Outline on a selected range
Ctrl + Shft + 7 .... Border Outline on a selected range
Ctrl + H + S + A ... Border all cells on selected range

Ctrl + H + B +N  ... Clear/delete borders
Ctrl + Shft + -  ... Clear/delete borders

Example:

Flash Fill

Flash fill is a new tool introduced in Microsoft Excel 2013, to fill out data based on an example.
 

Excel detect a pattern in your data, fill accordingly remaining data within a flash of time. It works best when your data has some consistency. Flash Fill is available in Data tab and Ctrl+E is a shortkey

Rather than manually entering first, middle, or last names in respective columns (or attempting to copy an entire client name from column A and then editing out the parts not needed in the First Name, Middle Name, and Last Name columns), you can use Flash Fill to quickly and effectively do the job.

For more detail check at office.com by clicking here.

Insert system date or time (Shortkey)

Shortcut keys to insert system date or time in a cell

for date ... Ctrl + ;
for time ... Ctrl + Shft + ;