Inserting columns & rows in worksheets

[Guest]

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

 

[Biff]

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

 

[Biff]

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

 

[Guest]

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.

 

[Guest]

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]

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

 

[Biff]

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