How to make horizontal auto fill in excel?

Help Robot
,
1

Hi,
I have cells that are horizontally in Excel. I used a formula to remove numbers from these cells. But I can’t auto fill all horizontal cells with this formula.
How can I do it?
Thanks,
Uploading: Adsız.png…

2

Adsız
Adsız1920×1021 17.1 KB

3

@hb61

Please use auto fill range activity…to fill the formula in given range

Cheers

4

Hi,
Auto fill only fills the formulas in the vertical cell up to the bottom rows.

5

Hi,
I solved the problem by converting the parts in the horizontal cell to vertical format and auto-fill.
The formula that allows the horizontal cells to be written in vertical format is as follows;
=TRANSPOSE(C2:I2)

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.