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.

750d1276195767-find-out-constants-spreadsheet-


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

749d1276195766-find-out-constants-spreadsheet-

Advertisement
  • http://www.facebook.com/kristen.cottle Kristen Hobaica

    How do I replace the constants with new data?