Search This Blog

Monday, August 30, 2010

Excel Shortcuts-4

Ctrl+Shift+@ Time format


Ctrl+Shift+# Date format

Ctrl+Shift+$ Currency format

Ctrl+Shift+% Percent format

Ctrl+Shift+^ Exponential format

Ctrl+Shift+& Place outline border around selected cells

Ctrl+Shift+_ Remove outline border

Ctrl+Shift+* Select current region

Ctrl++ Insert

Ctrl+- Delete

Ctrl+1 Format cells dialog box

Ctrl+2 Bold

Ctrl+3 Italic

Ctrl+4 Underline

Ctrl+5 Strikethrough

Ctrl+6 Show/Hide objects

Ctrl+7 Show/Hide Standard toolbar

Ctrl+8 Toggle Outline symbols

Ctrl+9 Hide rows

Ctrl+0 Hide columns

Ctrl+Shift+( Unhide rows

Ctrl+Shift+) Unhide columns

Alt or F10 Activate the menu

Ctrl+Tab In toolbar: next toolbar

Shift+Ctrl+Tab In toolbar: previous toolbar

Ctrl+Tab In a workbook: activate next workbook

Shift+Ctrl+Tab In a workbook: activate previous workbook

Tab Next tool

Shift+Tab Previous tool

Enter Do the command

Shift+Ctrl+F Font Drop Down List

Shift+Ctrl+F+F Font tab of Format Cell Dialog box

Shift+Ctrl+P Point size Drop Down List

No comments:

Post a Comment

Widget