MS EXCEL யூஸ் பண்றீங்களா? இந்த ஷார்ட்கட் எல்லாம் உங்களுக்கு தெரியுமா?

Complete List of MS Excel Shortcut Key




Ctrl+A - Select All

Ctrl+B - Bold

Ctrl+C - Copy

Ctrl+D - Fill Down

Ctrl+F - Find

Ctrl+G - Goto

Ctrl+H - Replace

Ctrl+I - Italic

Ctrl+K - Insert Hyperlink

Ctrl+N - New Workbook

Ctrl+O - Open

Ctrl+P - Print

Ctrl+R - Fill Right

Ctrl+S - Save

Ctrl+U - Underline

Ctrl+V - Paste

Ctrl W - Close

Ctrl+X - Cut

Ctrl+Y - Repeat

Ctrl+Z - Undo

F1 - Help

F2 - Edit

F3 - Paste Name

F4 - Repeat last action

F4 - While typing a formula, switch between absolute/relative refs

F5 - Goto

F6 - Next Pane

F7 - Spell check

F8 - Extend mode

F9 - Recalculate all workbooks

F10 - Activate Menubar

F11 - New Chart

F12 - Save As

Ctrl+: - Insert Current Time

Ctrl+; - Insert Current Date

Ctrl+" - Copy Value from Cell Above

Ctrl+’ - Copy Formula from Cell Above

Shift - Hold down shift for additional functions in Excel’s menu

Shift+F1 - What’s This?

Shift+F2 - Edit cell comment

Shift+F3 - Paste function into formula

Shift+F4 - Find Next

Shift+F5 - Find

Shift+F6 - Previous Pane

Shift+F8 - Add to selection

Shift+F9 - Calculate active worksheet

Shift+F10 - Display shortcut menu

Shift+F11 - New worksheet

Shift+F12 - Save

Ctrl+F3 - Define name

Ctrl+F4 - Close

Ctrl+F5 - XL, Restore window size

Ctrl+F6 - Next workbook window

Shift+Ctrl+F6 - Previous workbook window

Ctrl+F7 - Move window

Ctrl+F8 - Resize window

Ctrl+F9 - Minimize workbook

Ctrl+F10 - Maximize or restore window

Ctrl+F11 - Inset 4.0 Macro sheet

Ctrl+F1 - File Open

Alt+F1 - Insert Chart

Alt+F2 - Save As

Alt+F4 - Exit

Alt+F8 - Macro dialog box

Alt+F11 - Visual Basic Editor

Ctrl+Shift+F3 - Create name by using names of row and column labels

Ctrl+Shift+F6 - Previous Window

Ctrl+Shift+F12 - Print

Alt+Shift+F1 - New worksheet

Alt+Shift+F2 - Save

Alt+= - AutoSum

Ctrl+` - Toggle Value/Formula display

Ctrl+Shift+A - Insert argument names into formula

Alt+Down arrow - Display AutoComplete list

Alt+’ - Format Style dialog box

Ctrl+Shift+~ - General format

Ctrl+Shift+! - Comma format

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