In this Excel video tutorial, we gonna see How to Remove Blanks Rows in Excel with 3 Methods to Delete Empty Cells.
00:00 - Subscribe to the channel!
00:12 - Like the Video!
00:26 - 1st method
01:45 - 2nd method
03:11 - 3rd method
In the 1st method, we gonna select the entire data set and then press the shortcut key Ctrl G to open special cells selection and the we can choose blank cells.
The 2nd method, we gonna use the filters to see everything we information and everything with no data. And we can combine multiple filters to create an compound filter or we can coupled filters together in excel using many columns.
the 3rd method, we will use one of most important functions in excel, the count blank function or the count blank formula. Then, we can count not everything, but the blank cells. We can also use the filters to sort the blank values and then rid of them.
#JopaExcel #Dashboard #Excel
18 авг 2024