Inserting columns & rows in worksheets
 

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

Inserting columns & rows in worksheets
 

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" wrote in message
...
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

Inserting columns & rows in worksheets
 

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" wrote in message
...
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

Inserting columns & rows in worksheets
 

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" wrote in message
...
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" wrote in message
...
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