Find Out Constants In Excel 2010 Spreadsheet

In Excel 2010, constants are referred to as data set which doesn’t contain any formula/function or whose value does not change with variation in other data set.  It provides you with a handy option to view all the constants contained in your spreadsheet. To quickly view the constants in spreadsheet, navigate to Home tab and under Editing group, from Find & Select options, click Constants.

750d1276195767findoutconstantsspreadsheet Find Out Constants In Excel 2010 SpreadsheetView in gallery

This will immediately select the range containing constants, i.e data values without any function or formulas.

749d1276195766findoutconstantsspreadsheet Find Out Constants In Excel 2010 SpreadsheetView in gallery