No of visitors who read this post: 2433
Category: Softwares Talk
Type: Blog
Author: Louieroy
Average: 5 (219 votes)

MS ACCESS/ EXCEL / WORD / OUTLOOK SHORTCUTS

1. MS Access shortcuts

  • Ctrl plus page up button: it directs you to the first field of the current field.
  • Ctrl plus page down button: It directs you to the last field of the current field.
  • Ctrl plus home button: It directs you to the first record of the first field.
  • Ctrl plus end button: It directs you to the last record of the first field.
  • Home button: It directs you to the first field of the record.
  • End button: It directs you to the last field of the record.
  • Shift plus the F2 button: It allows you to open the Zoom dialogued box.
  • Ctrl button and a plus sign: It allows you to add a new record.
  • Ctrl button and a minus sign: It allows you to remove or delete the current record.
  • F2 button: It allows you to toggle between the navigation mode and editing mode.
  • Ctrl button plus semicolon: It allows you to enter the current data.
  • Ctrl button plus single quote: It allows you to repeat data that is from the field in the prior record.
  • Ctrl plus F8 button: It allows you to turn on move mode.
  • F5 button: It allows you to switch to form view.
  • F6 button: It allows you to switch between the upper or lower panes.
  • F7 button: It allows you to check spellings and grammar.
  • Ctrl button plus space bar: It allows you to select or unselect column.

2. MS Excel shortcuts

  • End button: It allows you to turn the End mode ON or OFF.
  • Shift button plus arrow key: It allows you to extend the selection to the last cell that is not blank and which is in the same column or row as the active cell END.
  • End button/Shift plus Home button: It allows you to extend the selection to the last cell on the worksheet that is used.
  • Ctrl plus shift button plus asterisks (*): It allows you to select the data area that is enclosed by empty columns and empty rows around the cell that is active.
  • Ctrl button plus back slash (/): It allows you to choose the present array where an active cell belongs to.
  • Ctrl plus shift plus O buttons: It allows you choose all the cells containing comments.
  • Ctrl button plus forward slash (\): It allows you to select the cells that do not match the value of the active cell in the same row.
  • Ctrl plus shift plus opening bracket button: It allows you to select cells that are only referred to by formulas in the selection.
  • Ctrl plus shift button plus opening brace: It allows you to select the entire cells that are referred directly or indirectly to by the formulas in the selection.
  • Ctrl button plus the closing bracket: It allows you to select cells with the formulas that refer to the active cell directly or indirectly.
  • Ctrl plus shift button plus closing brace: It allows you to select the cell that contains the formula referring to the active cell either directly or indirectly.
  • Alt key plus semicolon: It allows you to select the cells that are only visible in the present selection.

3. MS word shortcuts

  • Shift plus F5 button: It allows you to go back to the point that was edited last.
  • Shift button plus F3 button: It allows you to change the case of the selected text.
  • Ctrl plus the Enter button:It allows you to automatically insert breaks on the pages.
  • Ctrl plus shift plus N button: It allows you to change the format used on the selected text to normal style.
  • Ctrl plus shift plus C button: It allows you to copy the format of the selected text. The selected format can be applied by pressing the Ctrl plus shift plus V buttons on the selected text.
  • F4 button: It allows you to repeat the last action that you have of performed.
  • Ctrl plus F6 button: It allows you to cycle through all the opened documents in word.
  • Alt plus shift plus the Left button: It allows you to create main headlines.
  • Alt plus shift plus right button: It allows you to create subheadings.
  • Ctrl plus the O button: It allows you to apply or remove 12 points on top of the present paragraph.
  • Shift button plus the left/right arrow keys: It allows you to select single character of a text.
  • Ctrl button plus the F Key: It allows you to open the tab for find.
  • Ctrl button plus mouse drag: It allows you to copy the selected text or image.

4. MS Outlook shortcuts

  • Ctrl key plus the 1 Button: It allows you to open windows for mail.
  • Ctrl button plus the 2 Button: It allows you to open the calendar.
  • Ctrl button plus the 3 Button: It allows you to open your contacts.
  • Ctrl plus 4 button: It allows you to several tasks.
  • Ctrl plus the 5 button: It allows you to open notes.
  • Ctrl plus shift plus M button: It allows you to create new message in outlook.
  • Ctrl plus shift plus C button: It allows you to create new contacts.
  • Ctrl plus N button: It allows you to write a new message.
  • Ctrl pus R button: It allows you to reply a message.
  • Alt plus A button: It allows you to open the action drop down menu.
  • Alt plus B button: It allows you to open the Address book with the BCC field selected.
  • Alt plus C button: It allows you to choose message recipient for CC field.
  • Alt plus D button: It allows you to switch to the daily calendar view.
  • Alt plus E button: It allows you to the edit drop down menu.