You can then delete column D and column E. Now you’ve inserted blank rows between every two rows. Right-click any of them and choose Insert… in the menu. Step 2: Click inside the left, center or right Click to add header box and type the title of the spreadsheet. Then all the blank cells in the assistant columns are selected. Open the spreadsheet in Microsoft Excel 2013, cl ick the Insert tab and then click Header & Footer in the Text group to add a blank header to the top of each page of the spreadsheet. 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 |