Find and Remove Empty Cells, Rows and Columns in Microsoft Excel The Teacher
video description
Date: 2022-03-31
Related videos
Comments and reviews: 3
Noneya
That info was simple enough, but I'm trying to find how to clear empty cells that Excel still stores in memory. I have a sheet that when I hit CTRL+END it takes me to Column XFD, but the last used column is AA. I've deleted the entire range of columns, did the steps you showed here and others but Excel still thinks there is data in that range. Do you have any videos covering this issue? I'm using MS Office 365.
reply
That info was simple enough, but I'm trying to find how to clear empty cells that Excel still stores in memory. I have a sheet that when I hit CTRL+END it takes me to Column XFD, but the last used column is AA. I've deleted the entire range of columns, did the steps you showed here and others but Excel still thinks there is data in that range. Do you have any videos covering this issue? I'm using MS Office 365.
reply
Sukumar
In this case all columns were equal and had consistent blank rows AND columns. How if we have blanks in some columns while the other columns have data which needs to be retained while we want to delete only fully blank complete rows/columns.
reply
In this case all columns were equal and had consistent blank rows AND columns. How if we have blanks in some columns while the other columns have data which needs to be retained while we want to delete only fully blank complete rows/columns.
reply
rediryou
The problem is if one of your rows has some blank cells in it then when you delete sheet rows it takes them away also. I just need to find and select all blank rows and delete those only.
reply
The problem is if one of your rows has some blank cells in it then when you delete sheet rows it takes them away also. I just need to find and select all blank rows and delete those only.
reply
Add a review, comment
Other channel videos
