Type and Enter

Use of shortcuts in computer programs

Microsoft Office is widely used worldwide. Microsoft Word is used for creating documents, Excel is used for creating spreadsheets, Powerpoint is used for presentations. With such wide and extensive use, there are certain features or rather certain shortcuts which can be used from the keyboard to save a lot of time. Let us see some of the general keyboard shortcuts and those used in Excel:
General Keyboard Shortcuts:
  • To Open Help: Press F1.
  • For selecting entire content in a document, window, or text box: hit Ctrl+A together on same time.
  • For searching for a file or folder: Press F3. In Windows 7, one will have to hit Windows logo key to prompt the Start menu. After that type in the Search box.
  • For renaming in a file or folder: Select the file or folder, hit F2, and then retype the name.
  • To find out information about when the file or folder was made, by whom, and it’s size: Select the file, and then press Alt+Enter.
  • To display the Start menu: Press Ctrl+Esc. In Windows 7, you can also press the Windows logo key.
  • For scrolling between open windows: Press Alt+Tab, and then hold down Alt while pressing Tab to reach the desired file or program.
  • For undoing an action: Press Ctrl+Z.
  • For redoing an action: Press Ctrl+Y.
  • For checking the spelling of titles or words in any Office application with the Spelling & Grammar checker: Press F7.
  • To create a shortcut on your desktop to your favorite file or folder: In Windows 7: Right-click the file or folder. On the shortcut menu, click Send to, and then click Desktop (Create shortcut).
  • To capture a screen shot: Press Alt+Print Screen, and then press Ctrl+C to copy and Ctrl+V to paste.
  • For locking the computer, switching users, logging off the computer, changing the password or starting the Task Manager: In Windows 7, press Ctrl+Alt+Delete.
  • To lock the computer: Press the Windows logo key + L.
  • For quitting program: Press Alt+F4
Used in Excel:
  • Open a new workbook: Press Ctrl+N.
  • Move left to right, cell by cell: Press Tab, or press the Right Arrow key.
  • Move right to left, cell by cell: Press Shift+Tab, or press the Left Arrow key.
  • Move down, cell by cell: Press Enter, or press the Down Arrow key.
  • Move up, cell by cell: Press Shift+Enter, or press the Up Arrow key.
  • Move down or up to the last empty or non-empty cell: Press Ctrl+Shift+Down Arrow or Up Arrow.
  • Move to the last empty or non-empty cell to the right or left: Press Ctrl+Shift+Right Arrow or Left Arrow.
  • Erase data in the current cell: Press Backspace.
  • Insert a return within a cell: Press Alt+Enter.
  • Return to the beginning of the row: Press HOME.
  • Advance to the next worksheet: Ctrl+Page Down
  • Go to the previous worksheet: Ctrl+Page Up
  • Enter the date: Press Ctrl+Semicolon (;).
  • Enter the time: Press Ctrl+Shift+Colon (:).
  • Find out about the style within the cell: Press Alt+Apostrophe (‘).
  • Display the Format Cells dialog box: Press Ctrl+1.
  • Apply the general number format: Press Ctrl+Shift+Tilde (~).
  • Apply the currency number format: Press Ctrl+Shift+Dollar Sign ($).
  • Apply the percentage number format
  • Press Ctrl+Shift+Percent (%).
  • Apply a border
  • Press Ctrl+Shift+Ampersand (&).
  • Remove a border
  • Press Ctrl+Shift+ underscore (_).
  • Hide the selected columns
  • Press Ctrl+0 (zero).
  • Hide the selected rows
  • Press Ctrl+9.
  • Unhide hidden rows within a selection
  • Press Ctrl+Shift+opening parenthesis.
Hope these shortcuts help you a lot in getting the work done easily. Suggestions and discussions are always welcome.

No comments:

Post a Comment