Exam Preparation Group

GK, HISTORY, SCIENCE MATHS, ENGLISH, HINDI & MANY MORE

कंप्यूटर सामान्य ज्ञान शॉर्टकट keys

​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 – Displayy 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

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

Updated: July 19, 2017 — 5:55 am
Exam Preparation Group © 2016 Frontier Theme