Forum Discussion
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...
ShereenLavi After deleting the empty rows and columns, did you save the file, quit Excel and reopen the file, before re-trying Ctrl-End?
- Yes I did
ShereenLaviI would recommend selecting the empty rows, right click on the row numbers and use that delete and then do the same with the columns. Next I would also double check there are no objects on the sheet. You can try under Home -> Find & Select -> Go To Special -> and select 'Objects'
