How to Insert a new row to Excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-03-17 02:25 AM
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,
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-03-17 06:42 AM
Hello
Use the Select Action to highlight the entire row, then use the Insert Action with the Shift input parameter set to ""up
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-17 11:04 PM
Thank you Tim.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-17 11:07 PM
I could however select only one cell (like ""A162""). How could i select an entire row using Select?(Is there something like ""A162-K162""?)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-04-17 03:19 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-04-17 07:11 PM
How to select entire row, I am able to select only one cell at the time with Select method of MS Excel VBO
