peppermin_t
New Member
- Joined
- Sep 6, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Very new to Excel and had a question about copy pasting a value from a certain cell to other cells.
If for example there is a value 'Group number 1' in cell A4, and I wanted to paste that value in B1:B4, what kind of formula should I use?
Also how can I continue this automatic copy+paste throughout the whole sheet? (E.g. 'Group number 2' in cell A8 to B5:B8)
Is this even possible?
If for example there is a value 'Group number 1' in cell A4, and I wanted to paste that value in B1:B4, what kind of formula should I use?
Also how can I continue this automatic copy+paste throughout the whole sheet? (E.g. 'Group number 2' in cell A8 to B5:B8)
Is this even possible?