Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ralphael1
 
Posts: n/a
Default 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   Report Post  
CLR
 
Posts: n/a
Default

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   Report Post  
Ralphael1
 
Posts: n/a
Default



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   Report Post  
CLR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column lines Scudo New Users to Excel 3 July 10th 05 12:58 AM
Missing lines in chart w/x-axis with months 1-24... DendWrite Charts and Charting in Excel 2 May 10th 05 09:04 PM
Leader Lines Connecting Chart to Box TOMB Excel Discussion (Misc queries) 1 May 7th 05 06:02 PM
How do I delete filtered lines in Excel 2000? Nicola H Excel Worksheet Functions 1 February 8th 05 03:47 PM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"