GoTo Special in Excel
Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you to highlight cells that contain comments, constants or formula, blanks, Objects (pictures, buttons, etc), cells in rows or columns that are different from their neighbors, precedents and dependents, last cell in a sheet, and cells with conditional formatting or data validation.
Views: 846 | | by David
View this tutorial