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.
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).
Smart folders in iOS Mail allow you to view collections of certain types of email messages from all your email accounts. You can view all your unread messages, flagged messages, messages with attachments, or just important messages from certain people. Using smart folders can make it easier to sift through a cluttered inbox.
If you’ve installed a lot of apps on your Apple Watch, the Home screen might be getting a bit crowded. Wondering how you can remove rarely used apps from your watch? There are two ways to do it.
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.
The Mail app on your Apple Watch makes it possible to view emails and even reply to some. However, if you have several email accounts and get a lot of email, you might want to limit how much email you see at once.
Your Android device’s built-in Clock app can serve as an alarm clock, a kitchen timer, and a stopwatch for timing activities. You can create multiple alarms and timers, adjust the snooze times for your alarms and record lap times using the stopwatch.
Your iPhone can be used as an alarm clock, a stopwatch, and a timer. However, If you have an Apple Watch, you don’t have to take out your phone to use any of these tools. Your watch has built-in apps that perform the same functions.
If you have an Android phone or tablet with a small amount of storage, you probably keep uninstalling apps to make room for other ones. But there is a way to expand the storage of an Android device if it has an SD card slot.
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.
Since smartphones have become more commonplace, many of you have probably given up wearing a watch in favor of having your phone tell you the time. You can also use your iPhone as an alarm clock, a timer, and a stopwatch, as well as a large timepiece.
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.
The Apple Watch allows you to send text messages with your voice through the Messages app. But every time you do, it’ll ask you whether you want to send a message as text or as a voice recording. Here’s how to get rid of that prompt.
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.
When organizing your Home screens on your iPhone or iPad, you’ve probably noticed that a default name is given to each folder when you create it. iOS won’t let you delete the name and leave it blank, but there is a trick to getting around this problem.
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 you tap a key on the iOS keyboard, it will “pop up” so you know what key you’re pressing. This preview has long been a feature that you had to live with whether you liked it or not, but in iOS 9, you can disable it.
Are you finding that you’re not seeing new apps on the App Store, or that updates to apps won’t go away even after you’ve installed the updates? Here’s a simple fix.
That 15GB phone may seem like it has a lot of space, but after taking all those photos, syncing all that music, and downloading all those audiobooks, it could dwindle pretty quickly. With so many files on your device, how are you supposed to figure out which files are taking up the most space? We’ll show a couple of ways to analyze the storage on your Android device.
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.
Your Apple Watch relies on your iPhone to get notifications, view data, and even send messages and make calls. However, your Apple Watch is not completely useless without your iPhone. Here some things you can do on your watch when your phone is out of range.
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.