Excel - Trouble reducing the sheet to just the data

%3CLINGO-SUB%20id%3D%22lingo-sub-1427940%22%20slang%3D%22en-US%22%3EExcel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1427940%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20data%20goes%20from%20A1%20to%20K2438%3C%2FP%3E%3CP%3EBut%20when%20you%20click%20on%20control%20end%20the%20last%20cell%20in%20the%20sheet%20recognized%20is%20WVD2438%3C%2FP%3E%3CP%3ENo%20matter%20how%20I%20try%20to%20delete%20the%20columns%20and%20rows%2C%20the%20area%2C%20it%20always%20goes%20back%20to%20WVD2438%20when%20I%20click%20on%20Control%20End%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20reduce%20the%20footprint%20of%20this%20workbook%20which%20is%20like%2050%20tabs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1427940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428195%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683954%22%20target%3D%22_blank%22%3E%40ShereenLavi%3C%2FA%3E%26nbsp%3BAfter%20deleting%20the%20empty%20rows%20and%20columns%2C%20did%20you%20save%20the%20file%2C%20quit%20Excel%20and%20reopen%20the%20file%2C%20before%20re-trying%20Ctrl-End%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428423%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683954%22%20target%3D%22_blank%22%3E%40ShereenLavi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20didn't%20catch%20if%20you%20clear%20content%20or%20not.%20If%20not%2C%20stay%20on%20first%20cell%20of%20the%20first%20empty%20row%2C%20after%20that%20Ctrl%2BShift%2BEnd%20to%20select%20them%20and%20clear%20content%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20443px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195501i3B59AE098159B2C0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20save%2C%20close%2C%20open%2C%20test%20last%20cell.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20option%20is%20to%20use%20Inquiry%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20653px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195502iE6B2336EF92CF268%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428509%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428509%22%20slang%3D%22en-US%22%3EAre%20there%20empty%20cells%20in%20your%20sheet%3F%3CBR%20%2F%3EUsing%20Ctrl%2BEnd%20and%20using%20Ctrl%2BShift%2BEnd%20needs%20all%20the%20cells%20to%20be%20filled%20to%20expect%20the%20results%20you%20expect%20from%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431537%22%20slang%3D%22en-US%22%3EYes%20I%20did%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431546%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Trouble%20reducing%20the%20sheet%20to%20just%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431546%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683954%22%20target%3D%22_blank%22%3E%40ShereenLavi%3C%2FA%3EI%20would%20recommend%20selecting%20the%20empty%20rows%2C%20right%20click%20on%20the%20row%20numbers%20and%20use%20that%20delete%20and%20then%20do%20the%20same%20with%20the%20columns.%26nbsp%3B%20Next%20I%20would%20also%20double%20check%20there%20are%20no%20objects%20on%20the%20sheet.%26nbsp%3B%20You%20can%20try%20under%20Home%20-%26gt%3B%20Find%20%26amp%3B%20Select%20-%26gt%3B%20Go%20To%20Special%20-%26gt%3B%20and%20select%20'Objects'%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 WVD2438 when I click on Control End

 

I am trying to reduce the footprint of this workbook which is like 50 tabs

5 Replies
Highlighted

@ShereenLavi After deleting the empty rows and columns, did you save the file, quit Excel and reopen the file, before re-trying Ctrl-End?

Highlighted

@ShereenLavi 

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

image.png

After save, close, open, test last cell.

 

Another option is to use Inquiry

image.png

Highlighted
Are there empty cells in your sheet?
Using Ctrl+End and using Ctrl+Shift+End needs all the cells to be filled to expect the results you expect from it.
Highlighted
Highlighted

@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'