Friday, December 29, 2006

Ctrl+Shift+Numericals Excel Keyboard Shortcuts

Short Cut Name
Ctrl+Shift+` Apply General format
Ctrl+Shift+1 Apply Number format
Ctrl+Shift+2 Apply Time format
Ctrl+Shift+3 Apply Date format
Ctrl+Shift+4 Apply Currency format
Ctrl+Shift+5 Apply percentage format
Ctrl+Shift+6 Apply Exponential number format
Ctrl+Shift+7 Apply an outline border to selection
Ctrl+Shift+8 Select Box
Ctrl+Shift+9 Display hidden rows in selection
Ctrl+Shift+0 Display hidden columns in selection
Ctrl+Shift+[ Go to All the Precedents
Ctrl+Shift+] Go to All the Dependents
Ctrl+Shift+\ In a selected column, select the cells that don't match the value in the active cell.
Ctrl+Shift+. Copies the cell to theleft (similar to Ctrl+D)
Ctrl+Shift+, Fill as Above
Ctrl+Shift+' Fill as Above and let it edit
Ctrl+Shift+/
Ctrl+Shift+`
Ctrl+Shift+- Remove outline border from selection
Ctrl+Shift+: Insert the current time
Ctrl+Shift+= Insert Cee/Row Funcion- Similar to Insert>Cell Menu

No comments: