OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
If you delete a lot of emails when sifting through your Outlook inbox, you might have turned on the option to automatically empty the deleted items folder when exiting Outlook. That’s handy, but you most likely have to confirm the deletion of the emails every time.
Among the new features in Microsoft Office 2016 are some improvements to the user interface. For example, they added a background image to the title bar in each Office program, and an improved dark theme. Customizing the background and theme is easy, and we’ll show you how to do it.
To do basic arithmetic in Word, you normally have to open the Windows calculator to get your answers, then manually insert them into Word. However, there is a third-party add-in for Word that provides a popup calculator that will calculate numbers in your document, and automatically insert the answer.
If you have large workbooks with a lot of formulas on the worksheets, recalculating the workbooks can take a long time. By default, Excel automatically recalculates all open workbooks as you change values in the worksheets. However, you can choose to recalculate only the current worksheet manually.
When you delete emails, tasks, calendar items, or notes in Outlook, they are moved to the Deleted Items folder. This folder is not emptied until you do it manually–at least by default. If you want, you can have Outlook empty this folder automatically when you exit the program.
Say you’ve created an Excel workbook you need to distribute, but you can’t reveal the formulas you used in that workbook. We’ll show you an easy trick that allows you to copy a worksheet to another workbook and quickly remove the formulas, so only the results show.
Macros in Microsoft Office programs allow you to automate repetitive tasks, but some macros can be dangerous. Macros are bits of computer code and they’re infamous for containing malware that will infect your computer if you run them. Microsoft Office protects you from files containing macros by default.
The status bar at the bottom of Excel’s window can tell you all kinds of interesting information, such as whether Num Lock is on or off, the page number, and the average of numbers in selected cells. Even better, you can easily customize the status bar to show just the information you want.
A spelling exclusion list is a list of words you can force Word to flag as misspelled, even when they are listed in the main dictionary as correctly spelled words. We will show you how to add a custom list of words you want to always flag as misspelled.
In addition to the standard spell checking tool, Word, PowerPoint, and Outlook can also check spelling and grammar as you type, indicating errors using colored, squiggly lines under the text. However, if all the squiggly lines are too distracting, you can turn one or both of these features off.
In the US, we use a period, or point, as a decimal separator (1.23). The same is true in the UK and Australia. However, other European countries use the comma as a decimal separator instead. Different delimiters are also used for separating thousands groups (1,000).
If you create documents in Word with complex layouts, tables are a useful method of arranging your content. You can use the cells in a table to structure your text, images, and even other tables. And yes, you can even nest tables in Word and we’ll show you how.
If you’re concerned about protecting your email in Outlook from prying eyes, especially if you share a computer with others, you can protect the email in each Outlook account, as well as the calendar items, tasks, etc. by setting a password on each Outlook data (.pst) file.