**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

4af7c807-f086-48c9-9b78-4e6d0fc1d868.zip

Introducing the Plug & Play BOT, a ready-to-use UiPath workflow for Excel Automation that can be integrated easily with any project across different customers that too without any modification.

Updating formula is one of the common functionality that we come across in almost every RPA implementation for Excel Automation and every time the developers need to re-create the workflow to do this activity.

It fills the formula across all the rows of a column in an excel workbook by using the keyboard shortcuts for drag & drop formula in a cell range.

Successfully tested the execution for different customers. It works very well without any change in code.

1.  **Project repository details:**/Data/Input/Sample.xlsx
2.  Excel Drag & Drop Formula.xaml
3.  xaml

**project.json**

Plug & Play BOT, a ready-to-use UiPath workflow or Excel Automation across projects

Tech Mahindra - Drag and Drop Formula for Excel