Many commands in Word have keyboard shortcuts assigned to them, making it quicker to apply formatting, save the file, and perform other tasks on your documents. These keyboard shortcuts can be customized, and you can assign shortcuts to commands that do not currently have them.
One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Macros provide an ideal way to save time on predictable, repetitive tasks as well as standardize document formats – many times without having to write a single line of code.
There may be times when you want to create a new Excel worksheet based on an existing worksheet. You can easily copy an entire worksheet in Excel to a new worksheet in the same file or even to a new, separate workbook file.
When entering formulas in Excel, you may want to remind yourself, or someone else, what it was for in the future. Or you may want to add instructions to let users of your spreadsheet know what to do in certain cells.
By default, Excel recalculates all the formulas in your worksheet automatically when you open your worksheet or change any entries, formulas, or names on which your formulas depend. If you worksheet is large, with many formulas, this can take several seconds or minutes.
Microsoft attempted to make typing appear smoother in Office 2013 by adding a typing animation feature. If you’re a slow typist, you probably won’t notice it. However, if you type upwards of 80+ words per minute, this feature can be distracting and annoying.
Previous versions of Excel have had an option for viewing two spreadsheets side-by-side. However, Excel 2013 now makes it easier by allowing you to snap each spreadsheet (opened in separate windows) to each side of the screen.
You can’t normally “undo” an email sent by mistake. Some email clients have undo-like features, such as the “Recall” feature in Microsoft Outlook, but these won’t work most of the time.
There are times, when working on an Office document, that you might forget where you saved the file. If you need to find out where the currently open document is located, you can use Save As to find out. However, there is a quicker way.
Out of the box, Office 2013 is designed to integrate seamlessly with the cloud – just as long as it’s Microsoft’s SkyDrive service.
By default, when you use the save as… option to save e-mail messages and attachments in Outlook the items are saved in your My Documents folder. Here’s how to change that.
Recently, we showed you how to add a watermark to a document in Word 2013. You can also add a watermark to worksheets in Excel 2013; however, you must add them manually using the header and footer tools. We will show you how.
By default, when you paste text copied from elsewhere into Word 2013, you automatically get all the formatting with it. This formatting most likely does not match the rest of the content of your document and may not come in neatly.
A watermark is a faded, background image that displays behind the text in a document. It can be used to indicate a document’s status (confidential, draft, etc.) or to add a company logo. We’ll show you how to add watermarks to documents in Word 2013.
Office 2007 saw the addition of the Ribbon feature, which some users found confusing. However, you can use it to your advantage by adding your own custom tabs containing commands you use often. This allows for quicker and easier document creation.
The Mini Toolbar and Live Preview are features in Word introduced in Word 2007 and continued in Word 2010 and 2013. They can be useful for quick formatting and to preview possible formats. However, if these features annoy you, they are easy to disable.
If you have the option on for checking spelling as you type in Word 2013, you can easily add words to the custom dictionary, using the context menu. However, what if you want to add or delete many custom words, or even add specialized dictionaries?
When you open Word 2013, a list of recently opened documents displays on the left side of the screen. This list also displays when you select the Open option from within the program. If you would rather not see this list, it’s easy to disable.
Word 2013 offers a new feature, called PDF Reflow, that allows you to import PDF files into Word and edit the text as a Word document. You can then resave or export the text as a PDF file.
When you install any recent version of Microsoft Office, Microsoft assumes that you want to sign up for the Customer Experience Improvement Program (CEIP). There’s a check box during installation that’s selected by default and automatically signs you up for the program.
Do you sometimes wish that you could use Microsoft Word’s more useful features, such as auto-complete, automatic spelling correction, and Autotext, in other programs in Windows? PhraseExpress is a free program that allows you to do just that.
Printing out web pages you want a hard copy of can be a little hit and miss. Unlike other documents, it is not easy to tell exactly how many pieces of paper will be needed, and whether or not there will be any awkward clipping. Add to this the problem of wasting ink by printing out unwanted images and ads, and it is little wonder that many people resort to copying and pasting into a word processor. But by using browser add-ons and bookmarklets, you can gain control over what you are printing.
We recently looked at how you can make it easier to manage multiple inboxes in Gmail using the Multiple Inboxes Lab feature. This is a non-standard feature and it’s far from being the only one available to you. In fact there are numerous hidden features that can help you to get more from Gmail.
If you have upgraded to Office 2013, or Office 365, you may have run into problems opening files that have been emailed to you. Try to open a Word file you have received as an email attachment and you are likely to find that Word not only refuses to open the files, but fails to provide much in the way of help.
Recently we took a look at how you can take Gmail further by enabling some of the extra features that are available in the experimental Labs section. If you use Google Calendar to manage your schedule, there are numerous tools and options that can be added through the use of Calendar-specific Labs. Today, we will take a look to see just what’s available.