Basically, do the same thing except instead on inserting a column/row,
select the cell where you want the formula and enter the formula. It will be
entered on every sheet in the same cell. Be sure to ungroup the sheets when
done!!!!
Biff
"Wylie Coyote" <WylieCoyote[ at ]discussions.microsoft.com> wrote in message
news:DD5AD19F-4D47-4C6B-B316-E807158B5474[ at ]microsoft.com...
[Quoted Text] > Thanks Biff. Next question: if I want to insert a formula into one of the
> cells in this new column, how do I do that? The formula will be exactly
> the
> same in each worksheet, and will be located in the exact same cell in each
> worksheet. Is there any way I can do that in one shot, without having to
> repeat the function on each worksheet throughout the entire workbook?
> Thanx.
>
> "Biff" wrote:
>
>> Right click any sheet tab
>> Select: Select all sheets
>> Insert your column or row
>> Right click the sheet tab again
>> Select: Ungroup sheets
>>
>> Note: it is very important to remember to do the last step!!!!!!
>>
>> Biff
>>
>> "Wylie Coyote" <WylieCoyote[ at ]discussions.microsoft.com> wrote in message
>> news:C884D3BE-A7D0-4867-89F1-80EA91F73332[ at ]microsoft.com...
>> > How do I insert a column or row throughout all my worksheets in a
>> > workbook?
>> > I want to repeat the exact same transaction into each worksheet,
>> > without
>> > having to program each worksheet individually. Thanx
>>
>>
>>
|