PivotTables are used to analyze huge amounts of data. The number of rows used in a PivotTable depends on the type of analysis you are doing and the characteristics of the original data. If you need to determine how many rows are in a PivotTable, you can use the approaches described in this tip.
Track Changes is a handy tool for those who need to see how a document changes over time. If you have a long document with lots of changes, you may want to know how many words in the document were changed due to insertions and deletions. Here's how to get the information you want.
One way you can designate your responsibility for a document is to add your phone number to it. There is no need to add your phone number in the actual document text, however. Instead you can add your phone number to the properties that Word maintains for each document.
Dialog boxes are designed to be limited in scope, so that they cover only a portion of your screen. What if a dialog box fills the entire screen, however? How do you get it back to a more manageable size?
When working with charts and chart objects, Excel is very dependent on the mouse. If you don't want to use the mouse, but instead want to use the keyboard, the techniques to apply are not immediately evident. This tip explains how to select and resize a chart object in a worksheet, using nothing but the keyboard.
Read this ExcelTip: Using the Keyboard to Select and Resize a Chart Object
Microsoft Excel Tips - Learn Excel Faster!
If you use the arrow keys to move the insertion point through the document, you may have noticed that it can be slow going at times. If you want to speed up this type of movement, follow the simple shortcut described in this tip.