View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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