Have you ever wished, you never had to drag your mouse here and there to get things done? For those conversant with Microsoft word or excel, I am pretty sure you can relate, dragging the mouse here and there to a particular function when you have loads of work to accomplish within a short time can be tiring. I won’t bore you with any epistle, let’s go straight to the point here.

A keyboard shortcut is a key or combination of keys that you can use to access icon button functions while you are working on a PC, the icon name and keyboard shortcut are displayed when you place the mouse over the icon but everyone notices this or have time to understand this, so I have decided to list a number of shortcuts here to make you know more about your computer.

 

SHORTCUTS ON A PC

 

  • 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
  • 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+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
  • Ctrl + E – align center
  • Ctrl + J – justify
  • Ctrl + L – align left
  • Ctrl + R – align right
  • Alt + Tab – switch applications
  • Windows + P – Project screen
  • Windows + E – open file explorer
  • Windows + D – go to desktop
  • Windows + M – minimize all windows
  • Windows + S – search

 

  • CTRL + SHIFT + A? = To change already lower case text to upper case.

 

Thanks everyone I hope I saved some lives here. Feel free to add more if any was omitted.

And oh…  Kindly follow twitter:  @Aooms_ while you are at it. I follow back.)

#Aooms