Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS?
my sheet is set up this way:
no# date name 1 4/13/06 JOHN 2 4/13/06 JOHN 3 4/13/06 JOHN 4/13/06 JOHN 4/13/06 JOHN 4 4/13/06 JOHN 5 4/13/06 JOHN i HAD ENTERED INFORMATION ACCORDDINGLY BUT I LEFT OUT SOME NAMES IN BETWEEN ROWS SO I WENT BACK ADDED ROWS IN BETWEEN AND OF COURSE THE NEW ROWS AREN'T NUMBERED SO I WANT TO RE-NUMBERED OR SORT OUT THE NO# COLUMN SO IT IN ORDER. AS YOU CAN SEE ON THE TOP THE TWO ROW THAT I ADDED AREN'T NUMBERED AND I DONT HAVE A CLUE IN HOW TO DO IT W/O AFFECTING THE TEXT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Data from a number of rows and columns to one column | Excel Discussion (Misc queries) |