1. Home
  2. MS Office

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.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.