Home

Delete Excess columns and rows

%3CLINGO-SUB%20id%3D%22lingo-sub-570512%22%20slang%3D%22en-US%22%3EDelete%20Excess%20columns%20and%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-570512%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20with%20multiple%20sheets%20in%20the%20workbook.%20Everyone%20one%20of%20the%20sheets%20goes%20up%20to%20column%20XFD%20and%20row%201048576.%20I%20have%20tried%20to%20the%20clear%20all%20option%2C%20and%20saved%20the%20file%20after%20this%20but%20nothing%20changes.%20I%20have%20tried%20deleting%20the%20rows%20and%20columns%2C%20but%20they%20still%20remain.%20Any%20idea%20how%20to%20delete%20all%20these%20Rows%20and%20Columns%20that%20are%20useless%3F%3C%2FP%3E%3CP%3EWhen%20I%20add%20a%20new%20sheet%20to%20the%20workbook%2C%20it%20automatically%20creates%20a%20large%20sheet%20going%20up%20to%20column%20XFD%20and%20row%201048576.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-570512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-572370%22%20slang%3D%22en-US%22%3ERe%3A%20Delete%20Excess%20columns%20and%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-572370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342657%22%20target%3D%22_blank%22%3E%40Maneshb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20solution%20from%20a%20previous%20post%20to%20Hide%20the%20columns%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FNeed-help-with-Excel%2Fm-p%2F144356%23M3492%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FNeed-help-with-Excel%2Fm-p%2F144356%23M3492%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20does%20the%20trick.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Maneshb
Occasional Visitor

I have an excel file with multiple sheets in the workbook. Everyone one of the sheets goes up to column XFD and row 1048576. I have tried to the clear all option, and saved the file after this but nothing changes. I have tried deleting the rows and columns, but they still remain. Any idea how to delete all these Rows and Columns that are useless?

When I add a new sheet to the workbook, it automatically creates a large sheet going up to column XFD and row 1048576.

 

1 Reply

Hi @Maneshb 

 

Try this solution from a previous post to Hide the columns instead.

 

https://techcommunity.microsoft.com/t5/Excel/Need-help-with-Excel/m-p/144356#M3492

 

Hope that does the trick.

 

Cheers

Damien

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies