Jan 23 2021 09:58 AM
Jan 24 2021 11:06 PM
@Nathalyaphow Perhaps you mean this.
The auto fill will NOT work when you select cells like in the picture below. Active cell is B2 where I dragged the number from towards the right.
But selecting C2:E2 and double-click the "fill marker" (bottom right-hand corner in E2), then it will work.
Jan 25 2021 12:37 AM
Another option:
- stay on B2
- select entire range to copy, e.g. B2:H100
- Ctrl+D
- Ctrl+R