You may find you need to change multiple cells from one case to another in Excel. Maybe you imported data that came in all upper case, or maybe you convert headings on columns to upper case. Changing case is easy using some special functions.
RSS stands for “Really Simple Syndication” or “Rich Site Summary.” It’s a document specification that allows you to easily collect and organize web-based news and information from websites in a standardized format commonly called a feed, which is like a bookmark that actively updates itself.
The Common Feed List is a list of subscribed RSS Feeds that is saved with your Windows user profile. RSS clients, including Windows Internet Explorer and Outlook, use this list allowing you to configure your RSS subscriptions in one location for multiple readers.
Have you switched to Microsoft Word from WordPerfect? Do you remember the Reveal Codes feature in WordPerfect that made it so easy to see exactly how your document was formatted? Well, you can get that feature now in Word using a free tool called CrossEyes.
When you open an Excel worksheet or change any entries or formulas in the worksheet, Excel automatically recalculates all the formulas in that worksheet by default. This can take a while if your worksheet is large and contains many formulas.
To find a specific date in the calendar in Outlook, you can scroll through all the weeks and months. Or, you can save some time using the Go To Date feature and enter a date to which you want to jump.
We’ve previously shown you how to add keyboard shortcuts to symbols in Word 2013 to make it easier to insert them into your documents. Keyboard shortcuts can be added to symbols in Excel as well, but there’s no direct method.
Hundreds of symbols that are not available on your keyboard are provided in Microsoft Word for use in your documents. For example, you can insert fractions (½), a degree symbol (°), pi (π), or currency symbols, such as the British pound symbol (£).
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.
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.