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.



  1. It’d be great if excel could distinguish between constants that are numbers and those that are not.

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.