Home

extra rows and columns outside of my spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-653804%22%20slang%3D%22en-US%22%3Eextra%20rows%20and%20columns%20outside%20of%20my%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-653804%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20rid%20of%20all%20the%20extra%20rows%20and%20columns%20outside%20of%20my%20spreadsheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-653804%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-654026%22%20slang%3D%22en-US%22%3ERe%3A%20extra%20rows%20and%20columns%20outside%20of%20my%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654026%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%2F350574%22%20target%3D%22_blank%22%3E%40charlie1951%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%20rel%3D%22noopener%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%3EIn%20saying%20this%20the%20extra%20rows%20and%20columns%20do%20no%20harm%20to%20your%20workbook%20but%20if%20you%20want%20them%20visually%20gone%2C%20the%20above%20method%20will%20work%20a%20treat.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20does%20the%20trick%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
charlie1951
Occasional Visitor

How do I get rid of all the extra rows and columns outside of my spreadsheet

1 Reply

Hi @charlie1951 

 

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

 

In saying this the extra rows and columns do no harm to your workbook but if you want them visually gone, the above method will work a treat.

 

Hope that does the trick for you.

 

Cheers

Damien

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies