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.
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.
If you occasionally need to use mathematical symbols in your documents that aren’t available in Word’s “Insert Symbol” dialog box, there are a couple of easy methods for entering your own custom compound characters.
The Notes app in iOS 9 contains many improvements, like drawing sketches and adding photos, but arguably one of the more useful features is the undersung checklist. Here’s how to quickly turn text into a grocery list, to-do list, or wish list in the Notes app on iOS 9, OS X El Capitan, and iCloud.
Microsoft thought they were being helpful when they set up notifications for new email. However, a constant barrage of notifications can also disrupt your train of thought. You can turn the notifications off completely, or–better yet–you can set up Outlook to only notify you about important emails.
If you type a lot of complex names, acronyms, or made-up words on your Android device, you know how utterly annoying it is for Android to “correct” them to something else. Next time, add your custom words and phrases to the dictionary so they don’t get changed.
You can personalize your Apple Watch with different watch faces and “complications”, but if you really want to add a personal touch, the “Color” watch face has a cool Monogram complication, which allows you to display up to four characters on the watch face. The Monogram complication is more customizable than people realize, though.
iOS allows you to shake your phone to undo typing you just did in apps such as Messages, Mail, Calendar, Notes, or Contacts. It’s a handy feature, but it can also be annoying. If you tend to accidentally activate the “Shake to Undo” feature during your daily activities, you can now easily disable this feature in iOS 9.
You can add up to 2 GB of music to your Apple Watch so you can listen to music on your watch using a Bluetooth speaker or headphones even when it’s out of range of your iPhone. However, if you want to remove the music, that’s easily done.
Got a shiny new Apple Watch for Christmas? You’re probably wondering how to set it up and what to do with it. It’s a very useful smartwatch that can do many things. Read on to find out how to set up your Apple Watch, tweak its settings, and learn the many ways you can use it.
Your Apple Watch taps you on your wrist to alert you when you get a notification. This is called haptic feedback. If you have trouble feeling the taps, you can increase the intensity of the haptic alerts.
You probably secure your iPhone with Touch ID or a passcode. If you have an Apple Watch, you can secure that against unauthorized access as well. Additionally, you need to have a passcode enabled on your watch to be able to use Apple Pay.
Do you often misplace your iPhone? If you have an Apple Watch, it’s easy to find your phone using the ping feature, saving you the embarrassment or hassle of asking a friend or family member to call your phone to help you find it.
Your Apple Watch battery provides sufficient power to last for most of a typical day under normal usage. Apple estimates most people will get an average of 18 hours of battery life from one full charge, depending on use.
Handoff is the feature on Apple Watch and iPhone that allows you to start a task on one device and finish it on another. For example, you might check email on your watch and then switch to your phone to compose a reply.
If an app on your Apple Watch stops responding, or you just want to fully quit an app, there is a way to force the app to quit rather than rebooting the entire watch. The procedure is pretty simple.
As you install apps on your iPhone that have Apple Watch companion apps, the Home screen on your Apple Watch may get a bit disorganized, making it hard to find your apps. It’s easy to rearrange the app icons on your watch’s Home screen.
Your Apple Watch has a total of 8 GB of storage on it, with about 5.6 GB of usable space for apps, music, and photos. If you start running out of room, you can easily check which apps are taking up the most space.