If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
NUMBERING OF A COLUMN
I would like to use automatic number ascention in my 1st column, actually,
each row would ascend in number by 1 |
#2
|
|||
|
|||
D wrote:
I would like to use automatic number ascention in my 1st column, actually, each row would ascend in number by 1 Put 1 in A1 2 in A2 high lite both cells and the move the cursor to the lower right corner. the cursor will turn into a + drag the + down the column. gls858 |
#3
|
|||
|
|||
"gls858" wrote: D wrote: I would like to use automatic number ascention in my 1st column, actually, each row would ascend in number by 1 Put 1 in A1 2 in A2 high lite both cells and the move the cursor to the lower right corner. the cursor will turn into a + drag the + down the column. gls858 gls858, Thank you somuch for your help, I will give it a try. Meanwhile, Although your suggestion sounds way easier, this is how I got it to work: I typed 1 in A1, then highlighted the column, under edit, fill, series, then entered growth, column edit again, then checked trend, and fill It did the trick, all the way down to the very bottom! This is all so new to me, I have very little experience with computers at all, I really do appreciate your responding. Thank you again, D (I'll be back soon, I'm sure) |
#5
|
|||
|
|||
"Don Guillett" wrote: Having it go all the way to the bottom will make your workbook larger than needed or desired. From 24 to 2370 kb on a new wb -- Don Guillett SalesAid Software "D" wrote in message news "gls858" wrote: D wrote: I would like to use automatic number ascention in my 1st column, actually, each row would ascend in number by 1 Put 1 in A1 2 in A2 high lite both cells and the move the cursor to the lower right corner. the cursor will turn into a + drag the + down the column. gls858 gls858, Thank you somuch for your help, I will give it a try. Meanwhile, Although your suggestion sounds way easier, this is how I got it to work: I typed 1 in A1, then highlighted the column, under edit, fill, series, then entered growth, column edit again, then checked trend, and fill It did the trick, all the way down to the very bottom! This is all so new to me, I have very little experience with computers at all, I really do appreciate your responding. Thank you again, D (I'll be back soon, I'm sure) |
#6
|
|||
|
|||
Don,
Okay, I understand. I'll get to and see if I can delete, or just redo it per your instructions. I used a print selection to get around that for now, but What your telling me is that I'm using space unnecessarily then, correct? Thanks again. D "Don Guillett" wrote: Having it go all the way to the bottom will make your workbook larger than needed or desired. From 24 to 2370 kb on a new wb -- Don Guillett SalesAid Software "D" wrote in message news "gls858" wrote: D wrote: I would like to use automatic number ascention in my 1st column, actually, each row would ascend in number by 1 Put 1 in A1 2 in A2 high lite both cells and the move the cursor to the lower right corner. the cursor will turn into a + drag the + down the column. gls858 gls858, Thank you somuch for your help, I will give it a try. Meanwhile, Although your suggestion sounds way easier, this is how I got it to work: I typed 1 in A1, then highlighted the column, under edit, fill, series, then entered growth, column edit again, then checked trend, and fill It did the trick, all the way down to the very bottom! This is all so new to me, I have very little experience with computers at all, I really do appreciate your responding. Thank you again, D (I'll be back soon, I'm sure) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I sort by row instead of by column? | PercivalMound | Worksheet Functions | 7 | August 28th, 2006 10:41 PM |
How do I reference every "n" cell in a column in Excel? | Alma | Worksheet Functions | 2 | March 22nd, 2005 06:19 PM |
How to include a column with sequential numbering in a Union Query | Amit | Running & Setting Up Queries | 4 | January 26th, 2005 05:07 PM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |
Need to Sum one column for each row that is part of a group and then filter out dups | kukarooza | Worksheet Functions | 1 | July 8th, 2004 02:30 PM |