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)
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