In my excel sheet one cell contain the formula,i want to drag that formula to the remaining rows for that column.

I saw one post regarding this,but i m not able to get it.sorry for posting again.

i am attaching the sample excel sheet in that sheet, i want to copy the formula which is there for ‘fullname’ column for remaining rows.

Can you please help me in that.

thanks

ananthasample.xlsx (8.2 KB)

# How to copy formula to the whole column

Hi @Ananthaeswar2,

There is one way to do it using hotkeys as following.

Lets say you have 2 columns as A,B as data and Your formula is in Column C2 (C1 contains the headers).

- Copy your formula in C2 field by using
**Ctrl+C**. - Hit
**left Arrow**. - Hit
**Ctrl+Down**. The cursor will go to the last row which contains data (ending row of B Column with data.) - Hit
**Right Arrow**.The cursor will come to Column C. - Hit
**Ctrl+Shift+Up**. It will select the data which needs to be populated by Formula in C Column. - Press
**Ctrl+V**to populate the copied formula.

It will populate the formula in Column C’s data.

Hope it will help you.

1 Like

Hi @jibanjyoti

i posted one question

https://forum.uipath.com/t/how-to-search-specific-values-in-whole-excel-sheet/7862

can you please help on this.

thank you

Hi @neplecha,

I need few information in order to proceed.

- Are you using excel inside citrix/vm or it is in the same machine where you have Uipath Studio?
- Which method and which activity you are currently using to read data from excel file?

Waiting for your input…

Thanks,

Jiban