Enter same formula once for multiple sheets

xeven_

Active Member
Joined
Jan 20, 2012
Messages
297
(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? :confused:
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Trevor_S

Well-known Member
Joined
Oct 17, 2015
Messages
611
Office Version
  1. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Jul 23, 2007
Messages
4,676
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,335
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top