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.
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.
The Microsoft Office Upload Center was a new feature added to Office 2010 and still available in Office 2013 and 2016. It allows you to manage documents you upload to OneDrive. If you upload a lot of documents at a time, this can be a helpful tool.
Creating tables in Word is easy using the commands on the ribbon. However, if you want to quickly create a table without removing your hands from the keyboard, you can easily create a basic table using the keyboard.
By default, Word uses Arabic numbers (1, 2, 3, etc.) when you create numbered lists. However, you can change the numbers to a different type or to letters. The character after the number or letter can also be changed.
You can customize the bullets on bulleted lists in Word using different symbols and colors. However, what if you want to use your own picture as the bullets on your list? Replacing the standard bullets with pictures is easy and we’ll show you how.
A numbered list in Word is simply a series of numbered paragraphs. There may be times when you want to have a paragraph or two without numbering in the middle of a numbered list and then start the numbering again after the unnumbered paragraphs.
By default, the plain black circular bullets are used when creating bulleted lists. However, you can customize your bulleted lists. We will show you how to change the symbol used as the bullets on the list and how to change the color of the bullets.
If you have a label or heading on a spreadsheet in Excel that you want to center across a certain number of cells, there are couple of ways you can do this, with or without merging cells. We’ll show you both ways.
Macros in Word and Excel provide the ability to save time on predictable, repetitive tasks. You can record a series of actions into a macro and then simply click a button to run the macro and perform the task.
Creating and removing numbered lists in Word is easy using the “Numbering” command on the ribbon. However, if you prefer using the keyboard, there is a way to quickly create a numbered list using a keyboard shortcut.
The Track Changes feature in Word allows you to mark changes you make in a document so anyone else working on the document knows what changes you made. By default, these marks display on the printed document, but you can prevent them from showing.
If your worksheet takes up more than one page when printed, you can print row and column headings (also called print titles) on every page so your data is properly labeled, making it easier to view and follow your printed data.
We’ve shown you how to add “Page X of Y” to a header of footer of large spreadsheets in Excel. The same thing can be done in Word for longer documents. It’s a bit different than in Excel, so read on to find out how.
The recent release of Office 2016 adds some useful new features and improvements and is now the default version installed as part of Office 365. However, if you want to install Office 2013 instead or on another machine, that is easily done.
You can add text, such as page numbers, filename, worksheet name, and date, to the header and footer on your spreadsheet. But, what if you want the first page of your worksheet to have a different header than the rest? That’s an easy task to accomplish.