InterServer Web Hosting and VPS

Shortcut keys Windows and Ms office

Spread the love

Shortcut Keys in Windows and MS Office quite similar functions. Today, life is so fast everyone like to do work quickly.

Therefore we decided to share you a small but effective post for you. Hope this life-hack of the keyboard shortcuts will help you in your day to day work.

Windows and MS office Shortcuts

Shortcut keys Windows and Ms office

Control Key & Character Combination:

Ctrl + A – Select All
Ctrl + B – Bold selected text area
Ctrl + C – Copy
Ctrl + D – Fill the down black area
Ctrl + F – Find
Ctrl + G – Bold
Ctrl + H – Replace
Ctrl + I – Italic
Ctrl + K – Insert a hyperlink
Ctrl + N – New workbook
Ctrl + O – Open
Ctrl + P – Print
Ctrl + R – Nothing right
Ctrl + S – Save
Ctrl + U – Underlined
Ctrl + V – Paste
Ctrl W – Close
Ctrl + X – Cup
Ctrl + Y – Repeat
Ctrl + Z – Cancel
Ctrl + `- Toggle value / display of the formula

Control, Shift & Function Key combination works as

Ctrl + Shift + F3 – Create a name using the names of the row and column labels
Ctrl + Shift + F6 – Previous Window
Ctrl + Shift + F12 – Printing
Ctrl + Shift + A – Insert the argument names in the formula

Control, Shift and Special Arithmetic Symbol Character

Ctrl ++ – Insert
Ctrl + – – Delete
Ctrl + Shift + ~ – General Format
Ctrl + Shift +! – Comma format
Ctrl + Shift + @ – Time Format
Ctrl + Shift + # – Date Format
Ctrl + Shift + $ – Currency Format
Ctrl + Shift +% – Percentage Format
Ctrl + Shift + ^ – Exponential Format
Ctrl + Shift + & – Place the border of the outline around the selected cells
Ctrl + Shift + _ – Delete the border of the contour
Ctrl + Shift + * – Select the current region
Ctrl + Shift + (- Show lines
Ctrl + Shift +) – Show columns

Control and Function Key Combination

Ctrl + F1 – Open File
Ctrl + F3 – Set name
Ctrl + F4 – Close
Ctrl + F5 – XL, size of the restore window
Ctrl + F6 – Next Workbook Window
Ctrl + F7 – Move window
Ctrl + F8 – Resize Window
Ctrl + F9 – Minimize the workbook
Ctrl + F10 – Maximize or Restore Window
Ctrl + F11 – Inset 4.0 Macro sheet
Shift + Ctrl + F6 – Previous Workbook Window

Shortcut key Control, Shift with Tab Combination

Ctrl + Tab – In the toolbar: Next toolbar
Shift + Ctrl + Tab – In the toolbar: Previous toolbar
Ctrl + Tab – In a workbook: activate the next workbook
Shift + Ctrl + Tab – In a Binder: Activate Previous Binder
Tab – Next tool
Shift + Tab – Previous tool

Function Key works as

F1 – Help
F2 – Edit the text in Excel 
F3 – Paste the name
F4 – Repeat the last action
F4 – When entering a formula, switch between absolute / relative references
F5 – Goto
F6 – Next Pane
F7 – Spell Check
F8 – Extension of the mode
F9 – Recalculate all workbooks
F10 – Activate Menubar
F11 – New graph
F12 – Save As

Alt, Shift and Function key combination works as

Alt + Shift + F1 – New spreadsheet
Alt + Shift + F2 – Save
Alt + = – AutoSum
Alt + down arrow – automatic view list
Alt + ‘- Format Style Dialog

Control Key with Numbers

Ctrl + 1 – Format of the cell dialogue
Ctrl + 2 – Bold
Ctrl + 3 – Italic
Ctrl + 4 – Underlined
Ctrl + 5 – Strikethrough
Ctrl + 6 – Show / Hide Objects
Ctrl + 7 – Show / Hide Standard Toolbar
Ctrl + 8 – Toggle Outline symbols
Ctrl + 9 – Hide lines
Ctrl + 0 – Hide columns

Alt and Function Key Combination work

Alt + F1 – Insert a graph
Alt + F2 – Save As
Alt + F4 – Output
Alt + F8 – Macro dialog
Alt + F11 – Visual Basic Editor
Alt or F10 – Activate the menu

Shift and Control key Combination

Shift + Ctrl + F – Font drop-down list
Shift + Ctrl + F + F – Format Cell Dialog Box Font Tab
Shift + Ctrl + P – Point Size Drop-down list.

Function Key and Shift Key Combination

Shift + F1 – What is it?
Shift + F2 – Edit cell comment
Shift + F3 – Paste the function into the formula
Shift + F4 – Search Next
Shift + F5 – Find
Shift + F6 – Previous Panel
Shift + F8 – Add to the selection
Shift + F9 – Calculate the active worksheet
Shift + F10 – Popup menu display
Shift + F11 – New spreadsheet
Shift + F12 – Save

Spread the love