Got a lot of open documents you are working with? You can save them all at one time by just holding down the Shift key while displaying the File menu. A couple of the menu options change to allow you to perform functions on all the open documents.
Sometimes a macro command line can get very, very long. This can make it hard to understand when you look at it a month or so from now. It is better to break your command lines up into individual lines that are easier to understand and document.
Given a long list of names, part numbers, or what-have-you, you may need to determine the unique values within the list. The advanced filtering capabilities of Excel provide a very easy way to get the desired values.
If you have a document with many graphics, you know that Word can sometimes be slow in displaying all those graphics. This tip examines why this occurs and discusses some things you can try to speed up the display of those pictures.
Given a particular week number for a year, you may want to figure out the date of the last day in that week. There is no intrinsic function to derive the desired date, but you can use one of the formulas presented in this tip.
The reference marks used for endnotes are, by default, formatted "good enough" for most people. If you are one of those for whom good enough isn't good enough, you can exercise complete control on how the reference marks appear.
Select a large range of cells and you may later want to remove a few cells from that selection. This is not as easy as you might expect. Here's how to unselect those cells you don't want in the selection.
AutoText entries can provide quite a bit of flexibility and power in a document. If you want to share those entries with others, you need to remember that the entries are stored in templates, not in documents. This tip explains how to go about sharing the desired entries with others.
Microsoft Graph is great for displaying charts in a document, without the need to actually use Excel. However, your data may actually be in an Excel worksheet, and you want to import it into a Microsoft Graph datasheet. Here's how to do it.