Then, click the drop-down arrow to the right of any of the highlighted row numbers and select Delete Row. You can then delete column D and column E. Switch between the worksheet, the Ribbon, the task pane, and Zoom controls: F6: F6 If more than one worksheet is open, switch to the next one: Ctrl-F6 - WORKING WITH DATA Select a row: Shift. To delete multiple nonconsecutive rows, hold down the Ctrl (Windows) or Command (Mac) key on your keyboard and click the row numbers for the rows you want to delete. Now you’ve inserted blank rows between every two rows. Right-click any of them and choose Insert… in the menu. 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. Click Delete, if youre sure you want to delete the data on the worksheet.
EXCEL DELETE ROWS BETWEEN DATA FOR MAC HOW TO
Create 2 assistant columns and enter “1”in D2 and “2” in E3.ĭrag your mouse to select the cells from D2 to E3. Most users know how to check the data status in the bottom of an Excel sheet. From the options available, select the radio button for Blanks. Go to Home > (Editing Group) Find & Select > Go To Special. Learn how to prevent Excel from freezing or crashing when deleting rows. In our example, we will select the data range that extends from Column A to Column G. I dont know your data but youve got a lot of data and youre using formulas. Open the worksheet you want to insert alternate blank rows. Select the range of rows and columns that have the blank cells you would like to remove. 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. As a result, we want to delete all rows that contain empty cell in the. It’s not rare to insert a blank row between 2 existing rows as a new header while making specific spreadsheets like salary sheets. Choose Blanks and click on the OK button: Figure 7.
0 kommentar(er)
