When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference.
To turn this feature off, follow the instructions in this short video.
For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables.
________________
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.
Sometimes a VLOOKUP formula returns an #N/A error, even though you can see the value you’re looking for in the lookup table. The most common cause for this is a text “number” in one place, and a real number in the other place. See how you can fix that VLOOKUP problem.
Excel’s popup cell comments aren’t just for text. You can also display pictures in an Excel comment. This short Excel video tutorial explains the simple steps. For detailed written instructions see: Add a picture to a comment ______
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter. To remove the duplicates, follow the steps in this short Excel video tutorial. ______________
It’s easy to name a group of cells in Excel, then use that name for navigation. This Excel video tutorial shows you the steps. For a written Excel tutorial on naming ranges, see naming ranges in Excel. ______________