Shortcuts you never knew existed on your PC

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

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s