| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Hi,
Enter the following formula in cell A265 and then copy it down COUNT($a$264:a264)+1 Now if you delete any row in between, it will continue numbering from the previous number ant not from one. Regards, Ashish Mathur "Robbie" wrote: I have numbers 1 through 17 in cells A264 to A281. I want to be able to delete information in cell A266 and have the numbers adjust so that instead of having to retype all of my numbers in again, Excel will automatically adjust the numbers. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Multiple Data Validation Criterias | Excel Worksheet Functions | |||
| filling a forumla down a column from data across a row | Excel Worksheet Functions | |||
Hybrid Mode
