Like MS Word, MS Excel is part and partial of office work. From preparing a simple list of things to calculating data, we frequently use excel. In its usage, some of you, especially MS Office learners, face many issues such as blank rows. You can get the needed support from Microsoft through office.com/setup. Here are some useful tricks for your assistance:
- Opt for Manual Deleting
If you have a few couples of blank rows to remove the excel sheet, deleting manually is the easiest and quickest way. For this, select the blank rows you have to delete. To select the blank rows, hold the key CTRL and click on a blank row. Do the right-click and choose Delete from the displayed menu after selecting the blank rows in an excel sheet.
You can apply a ribbon command and keyboard shortcut for this process. For applying the ribbon command, click on Delete and select Delete Sheet Rows after going to the Home tab. And the shortcut key, press CTRL + – on your system keyboard.
- Use Go to the Special
Manual deleting will be a tiring and painful job if you have numerous blank rows in your datasheet. To delete all the blank rows, select a column of your datasheet including all rows (filled and blank). After that, choose A1 for example, hold the key SHIFT, and select the last cell of the sheet (A14 for example). Now, you can use Go to the Special. The steps are as follows:
Home tab → Find & Select →Go to the Special
For this, you can also use a handy shortcut trick for the Go To menu. To go to the Go To menu, press CTRL+G and click on the Special from the displayed menu. Now you need to select BLANK from the displayed options and press the OK button. With this, you will select only the blank rows from your datasheet. Now to delete the selected rows, do the right-click and select DELETE, go to Home tab → Delete → Delete Sheet Rows
- Use Find Command
It is very similar to the step mentioned above. The primary difference is that you will select the blank rows with the help of the Find command. First of all, select a column in your datasheet.
Home Tab → Find & Select → Choose the Find menu (CTRL+F)
- Leave the Find what input box blank after expanding the advanced options in the menu of Find. Select the entire Match Cell Contents option
- Do a search within the sheet
- Look in the Values
- Click on the Find All button to go to all the blank cells
- Delete all the selected blank rows as you have done above
Blank rows in your data-sheet can be annoying for you. With the use of any one of the three steps mentioned above, you can easily remove all the blank rows from your datasheet. You can contact the Microsoft care team to get all the requisite support by logging onto www.office.com/setupkey