How do I apply a formula to a whole column at once?

[Guest]

Having duplicate columns in some of the sheets in my workbook, I would
naturally only want to enter data once. I can see that I can link a cell
and then drag the formula down, but would like it to apply to the whole
column apart from the header rows, without having to keep extending the
formula down manually. Where can one enter a formula for a whole column?

As some of the rows in the parent column will not be required in the
'daughter', I would also like to be able to delete rows in the daughter
sheet, but still have the remainder linked to the right row in the parent.

I'm sure this must be more straight forward, than it sounds, but I'm rather
rusty on spreadsheets, and Excel is always amazing me as to just how clever
it is! (My version is only the 2003, by the way.)

Cheers for any more useful tips.

S

 

[Jim Cone]

Select the cells, enter the formula, press Ctrl + Enter
-or-
Enter the formula and double click the bottom right corner of the cell.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel program)

..
..
..

"Spamlet" <[email protected]>
wrote in message
Having duplicate columns in some of the sheets in my workbook, I would
naturally only want to enter data once. I can see that I can link a cell
and then drag the formula down, but would like it to apply to the whole
column apart from the header rows, without having to keep extending the
formula down manually. Where can one enter a formula for a whole column?

As some of the rows in the parent column will not be required in the
'daughter', I would also like to be able to delete rows in the daughter
sheet, but still have the remainder linked to the right row in the parent.

I'm sure this must be more straight forward, than it sounds, but I'm rather
rusty on spreadsheets, and Excel is always amazing me as to just how clever
it is! (My version is only the 2003, by the way.)

Cheers for any more useful tips.

S

 

[Guest]

Thanks Jim, that was nearly it, and enough to get me there.

Turns out I have to highlight the whole column then click in the top cell
while holding Ctrl; then = and click in appropriate cell of parent column;
then tick; then fill down arrow.

Getting there gradually!

Cheers,

S

 

[Guest]

And now I see the flaw in my idea...

Once I have filled down a whole column my spreadsheet is 'full' and I cannot
add rows or move data if some rows have been missed in the transposing.
Seems one has to drag down a limited number of rows at a time after all!

I expect there is some way of specifying that the number of filled rows in
sheet B should not be more than the number in sheet A, but this is getting
too complicated for me.

Cheers,

S