 |
|
|
| Author |
Message |
External
Since: Feb 04, 2004
Posts: 14
|
(Msg. 1) Posted: Tue Mar 09, 2004 8:56 pm
Post subject: Auto fill
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
Sorry - I entered numbers in the cells in the last posting, I meant to
enter cell references.
If I enter "=A1" in B1, "=A2" in B2, I can drag to auto fill the rest
of column B and it will fill in =A3, =A4, etc.
I need to know how to do this if I enter =A1 in B1, =A2 in C1.
I want to auto fill D1, E1, F1........IV1 with the seriess =A3,
=A4.....
Thanks |
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3828
|
(Msg. 2) Posted: Tue Mar 09, 2004 10:51 pm
Post subject: Re: Auto fill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <876de75f.0403091756.327a76f8.DeleteThis@posting.google.com>,
Steve.DeleteThis@SKSSolutions.com (Steve) wrote:
> Sorry - I entered numbers in the cells in the last posting, I meant to
> enter cell references.
> If I enter "=A1" in B1, "=A2" in B2, I can drag to auto fill the rest
> of column B and it will fill in =A3, =A4, etc.
>
> I need to know how to do this if I enter =A1 in B1, =A2 in C1.
> I want to auto fill D1, E1, F1........IV1 with the seriess =A3,
> =A4.....
>
one way:
B1: =INDEX($A:$A,COLUMN()-1)
Drag or copy to the right.<!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Feb 04, 2004
Posts: 14
|
(Msg. 3) Posted: Wed Mar 10, 2004 7:04 am
Post subject: Re: Auto fill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
JE McGimpsey <jemcgimpsey.RemoveThis@mvps.org> wrote in message news:<jemcgimpsey-2B7397.19511409032004.RemoveThis@msnews.microsoft.com>...
> In article <876de75f.0403091756.327a76f8.RemoveThis@posting.google.com>,
> Steve.RemoveThis@SKSSolutions.com (Steve) wrote:
>
> > Sorry - I entered numbers in the cells in the last posting, I meant to
> > enter cell references.
> > If I enter "=A1" in B1, "=A2" in B2, I can drag to auto fill the rest
> > of column B and it will fill in =A3, =A4, etc.
> >
> > I need to know how to do this if I enter =A1 in B1, =A2 in C1.
> > I want to auto fill D1, E1, F1........IV1 with the seriess =A3,
> > =A4.....
> >
>
>
> one way:
>
> B1: =INDEX($A:$A,COLUMN()-1)
>
> Drag or copy to the right.
GREAT!
Thanks so much!<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Auto fill |
|
| Back to top |
|
| |
External
Since: Feb 04, 2004
Posts: 14
|
(Msg. 4) Posted: Tue Mar 30, 2004 3:46 pm
Post subject: Re: Auto fill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Ok, how about the reverse?
I want to list in a column, the values in a row.
Column A reading down ahould have the values contained in A1, B1, C1,
etc.
What formula would I use there?
I've tried several, but the cell references don't change correctly for
me no matter what I make an absolute (column or row).
> Thanks so much!<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Auto fill |
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3828
|
(Msg. 5) Posted: Tue Mar 30, 2004 5:24 pm
Post subject: Re: Auto fill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <876de75f.0403301246.556c7e1.TakeThisOut@posting.google.com>,
Steve.TakeThisOut@SKSSolutions.com (Steve) wrote:
> Ok, how about the reverse?
>
> I want to list in a column, the values in a row.
> Column A reading down ahould have the values contained in A1, B1, C1,
> etc.
>
> What formula would I use there?
>
> I've tried several, but the cell references don't change correctly for
> me no matter what I make an absolute (column or row).
Same sheet?
A2: =INDEX($1:$1,ROW())
and copy down
Different sheet?
A1: =INDEX(Sheet2!$1:$1,ROW())
and copy down<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Auto fill |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
