Add row on random place in Excel

Hey guys,

In my process I would like to add a new row in my Excel sheet in-between my other rows. It has not a specific row number, it differs from case to case. I hope you can help me out :slight_smile:

Kind regards

There is one way:

Use Ctrl + g to bring up the GoTo feature. In this example I want to add a row above or below row 61.

image

Then use the Alt+h to activate the Excel Menu Bar

Then Click I > Insert Rows

Then R to Insert Sheet Rows. It will add one Row above Line 62.

In your case, 62 needs to be replaced with a Random number.

image

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.