Forum Discussion
ShereenLavi
May 29, 2020Copper Contributor
Excel - Trouble reducing the sheet to just the data
My data goes from A1 to K2438 But when you click on control end the last cell in the sheet recognized is WVD2438 No matter how I try to delete the columns and rows, the area, it always goes back to...
SergeiBaklan
May 30, 2020Diamond Contributor
I didn't catch if you clear content or not. If not, stay on first cell of the first empty row, after that Ctrl+Shift+End to select them and clear content
After save, close, open, test last cell.
Another option is to use Inquiry