OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE

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.

about 5 months ago - by  |  1 Reply

Microsoft Office lets you encrypt your Office documents and PDF files, allowing no one to even view the file unless they have the password. Modern versions of Office use secure encryption that you can rely on–assuming you set a strong password.

about 5 months ago - by  |  3 Replies

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.

about 5 months ago - by  |  2 Replies

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.

about 5 months ago - by  |  1 Reply

Naming a range of cells in Excel provide an easy way to reference those cells in a formula. If you have a workbook with a lot of data on the worksheets, naming ranges of cells can make your formulas easier to read and less confusing.

about 5 months ago - by  |  1 Reply

Your iPhone contacts will automatically come with you to a new phone–assuming that new phone is an iPhone, you’re backing up the contacts to iCloud, and you’re using the same iCloud account on both phones. But things get a bit more complicated if you want to do anything else.

about 5 months ago - by  |  3 Replies

By default, when you create a table in Word, it is aligned with the left margin. You may want to make your tables stand out a bit by indenting them, but this cannot be done using the same formatting tools you would use to indent a paragraph.

about 5 months ago - by  |  1 Reply

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.

about 5 months ago - by  |  1 Reply

Reinstalling Windows is a good way to fix serious problems with your computer, or just to get a fresh slate. But before you reinstall Windows, you should make a list of programs you currently have installed on your PC so you know what you want to reinstall on the new system.

about 5 months ago - by  |  45 Replies

Windows users may not want for much, but when it comes to OS X, there are still some items one might put on their feature wish list. Among these is the ability to get a “quick look” at images, PDFs, and other documents by pressing the spacebar.

about 5 months ago - by  |  1 Reply

Bookmarks in Word are useful for navigating through your document, allowing you to quickly jump to specific parts of it. You can add and remove bookmarks, but Word does not let you rename them. However, we’ll show you a way around that limitation.

about 5 months ago - by  |  1 Reply

Windows 10 includes a mysterious app named “App Connector” that has access to your location, camera, contacts, and calendars. This app was created by Microsoft, but Microsoft hasn’t officially explained what it does.

about 6 months ago - by  |  10 Replies

Microsoft Word and Outlook have long featured the ability to view “readability” statistics for what you’re writing, so you know how simple or complex you’re writing is. This can help ensure your writing is readable enough for your intended audience.

about 6 months ago - by  |  2 Replies

You’re working in a worksheet in Excel and you press one of the arrow keys on your keyboard to move to the next cell. But instead of moving to the next cell, the whole worksheet moved. Don’t panic. There’s an easy fix for this.

about 6 months ago - by  |  1 Reply

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.

about 6 months ago - by  |  2 Replies

Say someone sent you a Word document with a lot of images, and you want you to save those images on your hard drive. You can extract images from a Microsoft Office document with a simple trick.

about 6 months ago - by  |  5 Replies

By default, short dates in Excel are formatted using slashes (3/14/2016). If you use a lot of dates in your worksheets, and you prefer to put periods in your dates (3.14.2016), you can easily change the format.

about 6 months ago - by  |  1 Reply

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.

about 6 months ago - by  |  1 Reply

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.

about 6 months ago - by  |  2 Replies

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).

about 6 months ago - by  |  1 Reply

Most Mac applications use the operating system’s spell check feature, and share the same personal dictionary. So if you add a custom word to your dictionary in one application, other Mac apps won’t detect it as a typo in the future. But there’s no obvious way to remove a word from the dictionary if you accidentally add one.

about 6 months ago - by  |  1 Reply

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.

about 6 months ago - by  |  1 Reply

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.

about 7 months ago - by  |  2 Replies

You’ve added comments to your worksheet, and now you want to print it out–with those comments intact. However, Excel doesn’t print comments by default. Here are two ways to do it.

about 7 months ago - by  |  1 Reply

When working on a document in Word, you may find that you need to insert text from another Word document. Maybe you’re collaborating with others and combining multiple pieces, for example.

about 7 months ago - by  |  4 Replies