SOLVED

Issues deleting rows & columns beyond the last cell in excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-2607171%22%20slang%3D%22en-US%22%3EIssues%20deleting%20rows%20%26amp%3B%20columns%20beyond%20the%20last%20cell%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2607171%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20tech%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20keep%20my%20file%20size%20down%20and%20my%20sheets%20legible%20by%20deleting%20all%20rows%20and%20columns%20that%20are%20beyond%20the%20last%20cell.%20I've%20looked%20online%20how%20to%20do%20it%20and%2C%20even%20though%20I've%20identified%20the%20last%20cell%20correctly%2C%20I%20can't%20get%20rid%20of%20the%20excess%20rows%20and%20columns.%20I've%20tried%20clearing%20and%20deleting%20them%20and%20restarting%20the%20application%2C%20but%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20attaching%20a%20screenshot%20to%20better%20explain%20the%20issue.%20Cell%20E37%20is%20the%20last%20cell%2C%20however%20I%20can't%20get%20rid%20of%20the%20ones%20to%20the%20right%20and%20below%20it.%20Any%20suggestions%20on%20what%20to%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20advance%2C%20thank%20you%2C%3C%2FP%3E%3CP%3ERafa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2607171%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2608514%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20deleting%20rows%20%26amp%3B%20columns%20beyond%20the%20last%20cell%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2608514%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1119750%22%20target%3D%22_blank%22%3E%40ElRafaVaz%3C%2FA%3E%26nbsp%3BYou%20simply%20can't%20delete%20the%20grid%2C%20but%20you%20can%20%3CSTRONG%3Ehide%3C%2FSTRONG%3E%20the%20unused%20columns%20and%20rows.%20Select%20all%20columns%20F%20to%20XFD%2C%20right-click%2C%20Hide.%20Do%20the%20same%20for%20rows%2038%20to%201048576.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi tech community,

 

I'm trying to keep my file size down and my sheets legible by deleting all rows and columns that are beyond the last cell. I've looked online how to do it and, even though I've identified the last cell correctly, I can't get rid of the excess rows and columns. I've tried clearing and deleting them and restarting the application, but to no avail.

 

I'm attaching a screenshot to better explain the issue. Cell E37 is the last cell, however I can't get rid of the ones to the right and below it. Any suggestions on what to do?

 

In advance, thank you,

Rafa

2 Replies
best response confirmed by ElRafaVaz (New Contributor)
Solution

@ElRafaVaz You simply can't delete the grid, but you can hide the unused columns and rows. Select all columns F to XFD, right-click, Hide. Do the same for rows 38 to 1048576.

 

 

Got it. I thought it would work kind of like sheets where you can make sure that cells are not taking extra resources by deleting unused columns.

 

I guess in excel I have to do the 'Last Cell check' and hide the rest for legibility. Thanks @Riny_van_Eekelen