Then all the blank cells in the assistant columns are selected. Press Ctrl+G to call out the Go To window.Ĭlick Special… on the bottom left corner of the popping out window. Release your mouse, the number will be auto filled to all the selected cells with the format in D2:E3. Then put the cursor at the bottom right corner of E3, drag it to select all the cells in column D and column E. Create 2 assistant columns and enter “1”in D2 and “2” in E3.ĭrag your mouse to select the cells from D2 to E3. Open the worksheet you want to insert alternate blank rows. Instead of right-clicking one cell and choose to insert a new row manually, you can actually batch create new rows alternatively using AutoFill and Go To feature of Excel. It’s not rare to insert a blank row between 2 existing rows as a new header while making specific spreadsheets like salary sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |