MJaspering
New Member
- Joined
- Oct 2, 2023
- Messages
- 8
- Office Version
- 365
- 2021
- Platform
- Windows
Hey All,
I am looking for some help to see if is possible to fill absolute references across a series. Let's say I have the following data:
I then use F4 to make the second part of the initial formula an absolute reference.
Is there a way to make the second part of each other cell (or selection) in the row an absolute reference as well so that I end up with the below? Can this be performed down cells in a column as well?
I am looking for some help to see if is possible to fill absolute references across a series. Let's say I have the following data:
=A2/A1 | =B2/B1 | =C2/C1 | =D2/D1 | =E2/E1 |
I then use F4 to make the second part of the initial formula an absolute reference.
=A2/$A$1 | =B2/B1 | =C2/C1 | =D2/D1 | =E2/E1 |
Is there a way to make the second part of each other cell (or selection) in the row an absolute reference as well so that I end up with the below? Can this be performed down cells in a column as well?
=A2/$A$1 | =B2/$B$1 | =C2/$C$1 | =D2/$D$1 | =E2/$E$1 |