Microsoft Office Tutorials and References
In Depth Information
After performing these steps, a new icon appears on your Quick Access toolbar.
Excel's Data form can be handy (if you like that sort of thing) but is by no means ideal. If you like the idea of using
a dialog box to work with data in a table, check out my Enhanced Data Form add-in. It offers many advantages
over Excel's Data form. Download a free copy from my website: www.spreadsheetpage.com .
Duplicate values are determined by the value displayed in the cell — not necessarily the
value stored in the cell. For example, assume that two cells contain the same date. One
of the dates is formatted to display as 5/15/2013, and the other is formatted to display
as May 15, 2013. When removing duplicates, Excel considers these dates to be differ-