Hello,

Can anybody tell me how can I duplicate a row in a worksheet(I aim for identical rows, meaning stylings, borders, merged cells, data etc).I couldn't find a way.

P.S. What I actually want to achieve is duplicating a row in the middle of the spreadsheet, so that all the rows below are shifted by one row towards the bottom, but I could use only the duplication part, and I can carry on with the shifting afterwards.

Thanks:)