I have an Excel 2016 spreadsheet and I have added basic filters to the column headers. Is there a way to number the rows, but NOT have the numbers change when the filters are used? For example, I have 47 rows of data...if you select one of the filters and it results in only 10 rows of data showing, I want to see the rows numbered 1, 2, 3, etc. - I don't want the numbers to be affected by the use of the filter.

  • Are you trying to reference these numbers in a formula? – JaredT Jan 27 '17 at 21:07
  • No - I want users to select a filter but have the numbers remain static as they represent the order that tasks need to be completed – Lori Jan 30 '17 at 14:39

Create a Column at the left of your Data for the numbers include it wit the Filter and use this formula under the Header:

supposing B2 is the First Data before applying the filter and drag it down the column, then apply your criteria it will show 1,2,3...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.