numbering rows in a filtered worksheet

O

olga

i created a cloumn (not filtered) to number each of my rows but when i filter
my rows my number column oes not stay numbered it filters along with the
others even thow its not filtered!?!
 
D

David Biddulph

Select the exact range of cells you wish to filter before you apply your
filter.
 
G

Gord Dibben

Olga

All columns on a worksheet will be filtered when any one column is filtered.

The hidden rows are the entire row, not just the column(s) you select to filter
upon.


Gord Dibben MS Excel MVP
 
D

Debra Dalgleish

You can use a formula to calculate the row number. For example, in
column A, enter the following:
=SUBTOTAL(3,$B$2:B2)

where column B contains no blank cells.
Copy the formula down to the last row of data.

NOTE: Don't use this formula in conjunction with the Data>Subtotal
feature. When you choose to Remove Subtotals, it deletes the lines that
contain a Subtotal formula.
 
Top