How to delete blank rows or cells in Microsoft Excel 2019 - Methods to delete blank rows or cells

Time: 2022-03-06Source: Huajun Software TutorialAuthor: Big Beard

Recently, some friends have consulted the editor about how to delete blank rows or cells in Microsoft Excel 2019? Here is the Microsoft Excel guide for you Friends in need can learn more about how to delete blank rows or cells in 2019.

Step 1: Open the Excel 2019 file (as shown in the picture).


Step 2: Select the first column and press Ctrl + G, the positioning will pop up (as shown in the picture).


Step 3: Select targeting conditions (as shown in the picture).


Step 4: Select a null value (as shown in the picture).


Step 5: The selected null value will be displayed in the table (as shown in the figure).


Step 6: Right-click and select Delete (as shown in the picture).


The above is the entire content of how to delete blank rows or cells in Microsoft Excel 2019 brought to you by the editor. I hope it can help you.

Related articles更多>>

Popular recommendations