Re-numbering Rows

B

Brad L

New Member
Joined
Feb 5, 2009
Messages
34
After you filter out data, how to you re-number the row numbers so they are, again, consecutive?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Enter the number 1 in your first cell, hold down ctrl while you click and drag down with the fill handle (lower right hand portion of the cell).
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Counting Colored Cells
Replies
1
Views
62
dreid1011
dreid1011
A
  • Question
Formula to count consecutive numbers in each row of a data source
Replies
3
Views
348
DanteAmor
DanteAmor
M
  • Solved
Counting given amount of consecutives
2 3 4
Replies
37
Views
666
Marvo
M
Yecart77
  • Question
Formula working on first row but not subsequent rows
Replies
1
Views
86
awoohaw
awoohaw
E
  • Solved
Help deleting rows and creating range name via VBA
Replies
2
Views
112
EssKayKay
E

Forum statistics

Threads
1,214,920
Messages
6,122,269
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top