Enter same formula once for multiple sheets

[xeven_]

(Excel office 365)
I have this formula =(C3/D3)-1 in column B row 3 page 1, and it is to fill the subsequent rows in the column that has data in it. Is it possible to enter the formula in one sheet/page and it fill all other sheets so that I do not have to manually enter it 20 plus times?

 

[Trevor_S]

If you select multiple sheets (either by holding down the control key while you select them, or select the first the shift key and select the last), normally whatever you do in one sheet is replicated in the others selected.

 

[Trebor76]

Hi xeven_,

Try these three steps:

1. Ensure you at cell B3 on page 1
2. Press and hold down the Ctrl key and select each tab you want the formula to appear
3. Enter your formula

Your formula should now be in cell B3 of each tab you selected in step 2

HTH

Robert

 

[xeven_]

Awesome that worked! Thanks

 

[Trebor76]

You're welcome