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
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.