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.
This will immediately select the range containing constants, i.e data values without any function or formulas.
It’d be great if excel could distinguish between constants that are numbers and those that are not.
How do I replace the constants with new data?