Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbering lines
I know line numbering can be done automatically but it also places
headers and I do not want headers. I would like to start A1 with the number 100, then A2 with 101 and so on down the page. How can I do this? I appreciate your assistance. Ralph, the OLD one |
#2
|
|||
|
|||
After typing 100 in A1 and 101 in A2, highlight both of those cells and grab
the "handle" in the lower right corner of A2 and drag it down column A as far as you want numbers....... Vaya con Dios, Chuck, CABGx3 "Ralphael1" wrote in message oups.com... I know line numbering can be done automatically but it also places headers and I do not want headers. I would like to start A1 with the number 100, then A2 with 101 and so on down the page. How can I do this? I appreciate your assistance. Ralph, the OLD one |
#3
|
|||
|
|||
CLR wrote: After typing 100 in A1 and 101 in A2, highlight both of those cells and grab the "handle" in the lower right corner of A2 and drag it down column A as far as you want numbers....... Vaya con Dios, Chuck, CABGx3 Muchias Gracias amigo. It works great... Adios, Ralphael, the OLD one |
#4
|
|||
|
|||
You're welcome Raphael, thanks for the feedback..........
This method also works to re-order a column where you might have deleted a bunch of rows and consequently a bunch of numbers in column A, just go back to A1:A2 and repeat this process and it will overwrite all the old numbers and return the column to sequential numbers......... Vaya con Dios, Chuck, CABGx3 Vaya con Dios, Chuck, CABGx3 "Ralphael1" wrote in message oups.com... CLR wrote: After typing 100 in A1 and 101 in A2, highlight both of those cells and grab the "handle" in the lower right corner of A2 and drag it down column A as far as you want numbers....... Vaya con Dios, Chuck, CABGx3 Muchias Gracias amigo. It works great... Adios, Ralphael, the OLD one |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column lines | New Users to Excel | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
Add more lines and more columns in Excel | Excel Worksheet Functions |