Forum Discussion
How to duplicate the row
Example
Money row 1
Coin row 4
Is there any way to repeat row 2 n 3 as money and 5 n 6 as coin as I have hundreds line to do. Thanks
Money row 1
Coin row 4
Is there any way to repeat row 2 n 3 as money and 5 n 6 as coin as I have hundreds line to do. Thanks
1 Reply
To do so, follow these steps...
- Select all the cells in column A with data and including blank cells.
- Press Ctrl+G to open Go To window and click on Special and choose Blank radio button.
- The above step would select all the blank cells in column A in the selected range.
- Now, type = from your keyboard and press UP Arrow key and press Ctrl+Enter.
- Then select the whole range again, copy it and paste it back as Values only.
