Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
REQ: Columns to rows or Rows to Columns | Excel Discussion (Misc queries) | |||
How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) |