Most periods should be followed by at least one space. What if you think there may be some errors in how your post-period spacing appears? You can use the search techniques presented in this tip to locate the problem areas.
When you record a macro, Word very literally records what you do. This includes filling in various settings in dialog boxes. How you change those settings is the subject of this tip. (Hint: Don't rely on the dialog box; change the command that results from the dialog box.)
Need to find a median value in a series of values? It's easy with the MEDIAN function. What isn't as easy is to derive the median from only a subset of the values based upon some criterion. Here's an easy way to approach the task.
When you refresh the data in a PivotTable, Excel can play havoc with whatever formatting you applied. Here's how to protect your formatting efforts when updating the information.
Read this ExcelTip: Maintaining Formatting when Refreshing PivotTables
Microsoft Excel Tips - Learn Excel Faster!