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).
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.
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.
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.
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.
Excel’s spell check feature doesn’t have all the bells and whistles that Word’s does, but it does provide basic spell-checking functionality. You can check the spelling of words in the cells of a worksheet and add words to the dictionary.
By default, when you type information into Excel and then press “Enter”, Excel will move the selection box one cell down. However, what if you want to enter information from left to right instead?
When creating formulas in Excel, you can reference cells from another part of the worksheet in your formulas. But if you have a lot of formulas, all those cell references can get confusing. There’s an easy way to remove the confusion.
Windows 10 comes with a built-in Mail app, from which you can access all your different email accounts (including Outlook.com, Gmail, Yahoo!, and others) in one single, centralized interface. With it, there’s no need to go to different websites or apps for your email. Here’s how to set it up.
AutoText entries are reusable chunks of text you can insert into documents using just a few keystrokes, saving you a lot of typing. However, you can add keyboard shortcut keys to AutoText entries, making it even faster.
Most of the time, Microsoft Word works flawlessly and makes our work much easier to do, but there are times when a particular built-in “feature” serves as a constant source of frustration rather than being helpful. Today’s SuperUser Q&A post has a quick and easy solution to help a reader disable a problematic feature.
We all have a few large chunks of text we have to type regularly–like your address, long names or phrases, or even tables and images you use often. The AutoText feature in Word allows you to store these chunks of text and quickly insert them with a few keystrokes, so you can waste less time typing.
If you use a few Excel spreadsheets daily, it would be handy if you could open those spreadsheets automatically every time you start Excel. Thankfully, Excel has this feature built-in–if you know where to look.
If you’ve been using Outlook for any significant amount of time, you probably have a few rules set up to help you manage your tidal wave of email. If you have a new computer, or you’re reinstalling Windows, you don’t need to set them all up again–just export them.
Apple’s Pages is perfectly acceptable as a word processor on the Mac. But most people use Microsoft Office, and iWork isn’t even available for Windows. So if you have an iWork document, and you or someone else needs to open it in Microsoft Office, you’ll have to convert it first.
If you’re working with different currencies in one Excel spreadsheet, you’ll need to change the currency symbol on certain cells, without affecting other cells. When you format your numbers as “Currency”, you can easily use multiple currency symbols in the same Excel spreadsheet.
Need to create a cover page for a report you’re writing? You can create a simple, but professional cover page by centering the text both horizontally and vertically. Centering text horizontally on a page is easy, but vertically? That’s also easy and we’ll show you how.
By default, Outlook displays the number of unread messages on most Mail folders. That’s handy on the “Inbox” folder, but what if you want to know how many total messages (unread and read) there are in other folders, such as the “Deleted Items” folder or custom folders?
You probably have some text that you type often in your Word documents, such as addresses. Instead of retyping this text every time you need it, you can put this common text into one Word document and reference it in other documents–it’ll even automatically update in all your documents if you change it.
When dealing with currency in Windows and Windows programs, such as Excel, Windows uses its default currency symbol. If you want to use a different symbol (say, Euros instead of Dollars), it’s easy to change using a setting in Window’s Control Panel.
Fields in Word are bits of code that are placeholders for data that changes. For example, when you insert page numbers into the header or footer of a document, Word actually creates a field that inserts the correct page number on each page.
If you’re using Word, Excel, or PowerPoint 2016 and you often share your files with people using older versions, it can get tedious to select the option for saving files in the old format every time. Here’s how to change the default file format for the Save dialog.
The Calendar app included with Windows 10 is a modern, universal app that integrates wonderfully with Mail and other Windows 10 apps. If you’re looking for a place in Windows 10 to manage your days, weeks, and months, here’s how to set up a Calendar in Windows 10’s Calendar app.
If you have a VBA function that turns Microsoft Excel into a CPU munching beast, is it possible to tame things down so that you can continue to use your computer for other activities while Excel is finishing up? Today’s SuperUser Q&A post comes to the rescue to help a frustrated reader get Excel back under control.