Whether you’re trying to finish some important projects on a laptop, or you’re just tired of reaching back and forth for the mouse whenever you’re putting together an excel report, there are a multitude of keyboard shortcuts that are built into the Office suite that can help get things done faster. With these, you won’t have to spend nearly as much time combing through the toolbars for the right button.
New: In all Office applications, Pressing Ctrl + N will open up a new, blank document of the same application type. For example, pressing this combination in Excel will generate a separate spreadsheet.
Cut: Whenever you’re doing any serious writing in Office, it can be handy to remove text or images without necessarily deleting them completely. Ctrl + X will remove selected items, and put them in the system clipboard for potential use in the future.
Copy: Copying and pasting often go hand in hand, which is why it’s very convenient that the keyboard shortcuts for them are close together. Ctrl + C will copy items without removing them.
Paste: Ctrl + V will paste anything that is copied or cut into the system clipboard to wherever your cursor is in the document. The same copied item can be pasted multiple times, if the situation calls for it.
Undo: Ctrl + Z will undo whatever the last action performed was. Most Office applications keep a buffer of the last dozen or so actions, so documents can be returned to a much earlier state.
Underline: This will re-format any selected text so that an underline appears beneath it. After highlighting the target material, press Ctrl + U.
Italics: This tools works in much the same way as other text formatting shortcut. Pressing Ctrl + I when text selected with convert that text to Italics.
Bold: This is one that’s useful for subheadings, and words that need some additional emphasis. Naturally, Ctrl + B once you’ve selected the necessary words will bold them.
Find: Sometimes you need to hunt through extremely long documents, looking for a particular portion to edit. Ctrl + F will allow you to search for certain terms more quickly. This function also works in Windows outside of Office applications.
Select All: The perfect way to quickly select an entire document so that broad changes in font or formatting can be made. Ctrl + A selects everything editable in the active window.
Print: This is a useful shortcut for sending finished documents off to the printer. Ctrl + P brings up the print dialog box, and pressing Enter right after will quickly print with the default settings.
Open: This is useful for pulling open previous documents if you already have the Office application open. Ctrl + O brings you to an Explorer window in which you can search for compatible files. Many Office programs will have a list of recently opened files, which can simplify searching.
Save: This may be the most frequently used function of all, no matter what you happen to be working on. Ctrl + S will quickly save the document you’re working on. If the file has never been saved before, it will bring up a dialog box where you can name the document.
Insert Date: Using this shortcut will automatically insert the current date wherever you have the cursor placed, based on your system’s calender. To do this, press Ctrl + Shift + 3 (or Ctrl + #).
Insert Time: Along the same lines as the date insertion function, you can insert the current time into documents more quickly than typing it out by pressing Ctrl + Shift + ; (or Ctrl + :).
Cycle Between Open Programs (Alt-tabbing): If you’re into multitasking, you probably have several applications open at any given point of your work day. Instead of having to click on the taskbar to bring different ones to the front, holding Alt while pressing Tab will allow you to scroll through all of your active windows. Releasing Alt will bring whichever one is selected to the front.
Left Align Text: In most applications, left alignment is the default setting. Still, if a paragraph of selected text needs this done, Ctrl + L is the way to do it.
Right Align Text: Right alignment may be more desirable in certain circumstances. This is particularly useful in Excel spreadsheets, for making rows of data easier to read. Simply select the item, and press Ctrl + R.
Center Text: Centering text is most useful for titles, or for any items that you want more attention called to. Ctrl + E will move whatever you have selected to the center of the page.
Convert to Hyper-link: This provides a way to quickly create a link within your text that can then be clicked by a reader, launching a browser and taking them to the destination. Ctrl + K will bring up the hyper-link dialog box, and any selected item will become a link to the URL you provide.
Related readings:
1. Extend Office 2010 Trial Period
2. Create And Share Office Document With Facebook Friends
Those shortcuts really help, I can’t live without them 🙂