Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861,
A3 = H03862 ------ yes I feel very stupid asking this! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
HI
Type the first 2 numbers in A1 and in A2 then click the bottom of cell 2 and drag down has far has you like. They will increment by themselves HTH John "dawn brist" wrote in message ... I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
Hi Again
I should have said select both cells grab the bottom of second cell and drag down HTH John "dawn brist" wrote in message ... I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
Entering first cell is enough and it is not necessary to enter second figure.
"John" wrote: HI Type the first 2 numbers in A1 and in A2 then click the bottom of cell 2 and drag down has far has you like. They will increment by themselves HTH John "dawn brist" wrote in message ... I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
Maybe slightly easier?
Enter H03860 in A1 then right-click and drag. Release and "Fill Series" Gord Dibben MS Excel MVP On Mon, 2 Feb 2009 15:32:27 -0500, "John" wrote: Hi Again I should have said select both cells grab the bottom of second cell and drag down HTH John "dawn brist" wrote in message ... I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a Column....
"dawn brist" wrote in message ... I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this! You should be aware that what you wish to do is not to *format* the column: I would describe it as "extending a value within a column". 'John' has said here how this is done. The same thing can, of course, be done horizontally - extending a value within a row. This dragging facility has other uses, too. If you put a 'day', 'month' or 'date' in A1 (say Monday or January or 02/02/2009), the same dragging process (horiz. or vert.) can be used to populate automatically adjacent cells with Tuesday, Wednesday, Thursday, etc. or February, March, April, etc. or 03/02/2009, 04/02/2009, etc. Hope this helps! Isn't Excel bluddy marvellous? Is there *anything* that can't be done with it - if you know how, of course! But I'm very much a newbie. -- DB. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with Column to row formatting | Excel Worksheet Functions | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
formatting a column | Excel Worksheet Functions | |||
Formatting a row into a column | Excel Worksheet Functions | |||
column to column conditional formatting won't work, need formula | Excel Worksheet Functions |