With this method, you can delete empty rows in Excel software using only 2 shortcut keys. Select Shift cells up and then click OK.The ‘Go To’ dialog box appears. Then in the Special section > click on blanks > then click OK.This range contains blank rows. Key Ctrl + G to press on your keyboard. In sheet1 we have a series of information. Column A contains the list of representatives and columns B to E contain the numbers. As you can see in the image below, we have an empty row after each entry. Now we want to delete the blank lines.įollow these steps to delete blank lines: Let’s take an example to better understand how to delete blank lines. Main path: Home > Find & Select > Go to Special. Now use Control minus to delete, and choose Entire row. At this point, every blank cell in column A is selected. Then select the column, and use Ctrl + G for Go To.Then Special, then select Blanks. In this case, Column A should always have a name. Excel Details: First, pick a column that should always contain data. Now, Im going to do this with keyboard shortcuts, so CONTROL+G for GO. ![]() ![]() ![]() This option allows direct access to various cells in Excel. You can enter the cell address in this window and find it quickly. Excel tutorial: Shortcut recipe: delete blank rows. When you choose the whole row, and then were going to use FIND & SELECT, GO TO SPECIAL.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |