topic I could however select only in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77217#M29505 I could however select only one cell (like ""A162""). How could i select an entire row using Select?(Is there something like ""A162-K162""?) Wed, 05 Apr 2017 22:07:00 GMT JosephJohn 2017-04-05T22:07:00Z How to Insert a new row to Excel https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77214#M29502 I am working on designing a solution where two different excel sheets are compared. I have to add a row from one excel page to another. For this i am initially inserting a new row at a particular position and adding the cell values. Is there a way to insert a new row at a particular position in an excel document? Is that using the in built Excel VBO/ using a keystroke approach? Thanks, Tue, 28 Mar 2017 01:25:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77214#M29502 JosephJohn 2017-03-28T01:25:00Z Hello https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77215#M29503 Hello Use the Select Action to highlight the entire row, then use the Insert Action with the Shift input parameter set to ""up Tue, 28 Mar 2017 05:42:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77215#M29503 TimGrassam 2017-03-28T05:42:00Z Thank you Tim. https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77216#M29504 Thank you Tim. Wed, 05 Apr 2017 22:04:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77216#M29504 JosephJohn 2017-04-05T22:04:00Z I could however select only https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77217#M29505 I could however select only one cell (like ""A162""). How could i select an entire row using Select?(Is there something like ""A162-K162""?) Wed, 05 Apr 2017 22:07:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77217#M29505 JosephJohn 2017-04-05T22:07:00Z You can do the same by going https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77218#M29506 You can do the same by going to the cell ""A162"" and to select the entire row use send key events ""Shift + Right arrow/End."" Regards, Ravinder Saini Mon, 17 Apr 2017 14:19:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77218#M29506 Ravindersaini 2017-04-17T14:19:00Z How to select entire row, I https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77219#M29507 How to select entire row, I am able to select only one cell at the time with Select method of MS Excel VBO Thu, 27 Apr 2017 18:11:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Insert-a-new-row-to-Excel/m-p/77219#M29507 ArunSingh 2017-04-27T18:11:00Z