Copying formulas into Multiple Worksheets

  • Thread starter Thread starter rbrychckn
  • Start date Start date
R

rbrychckn

Hi All,
I have a simple question to start off:
I have many worksheets that are of the same format and want to copy the
same array formula to many sheets (all in the same absolute cell). Is
there any easy way to do this? as opposed to going to each sheet and
cutting and pasting individually?

This is the formula:
{=IF(ISBLANK(B3:B100),"",MIN(IF((B3:B100<>0),(E3:E100))))}
and I want to add it to M20 in all sheets. Any help is appreciated

Tom
 
One way, copy the formula from the formula bar (do not copy the cell)
select the first sheet where you want this formula, hold down shift and
select the last sheet,
select M20, click in the formula bar and paste the formula, enter with ctrl
+ shift & enter
Right click one of the grouped sheet tabs and select ungroup sheets
 
rbrychckn said:
Hi All,
I have a simple question to start off:
I have many worksheets that are of the same format and want to copy the
same array formula to many sheets (all in the same absolute cell). Is
there any easy way to do this? as opposed to going to each sheet and
cutting and pasting individually?

This is the formula:
{=IF(ISBLANK(B3:B100),"",MIN(IF((B3:B100<>0),(E3:E100))))}
and I want to add it to M20 in all sheets. Any help is appreciated

Tom
Click to expand...

Group the worksheets: Click the tab of the first and then hold down Shift
whilst clicking the tab of the last.
Then, whatever you do on the visible worksheet will be done on them all.
So, select M20.
Then array-enter your formula just as you would for one worksheet.

Don't forget to ungroup the worksheets before doing anything else! Click on
another worksheet tab, or right-click the tab of one of the group and use
Ungroup Sheets.
 
You can hold down 'Ctrl' key and click each sheet tab you want to include.
With all sheets selected, just enter the formula in M20 and it should appear
on all sheets at once.

Amit
 
Back
Top