Home

How do I delete unused rows and columns in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-386364%22%20slang%3D%22en-US%22%3EHow%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386364%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20single%20one%20page%20document%20in%20Excel%20without%20all%20the%20extra%20unused%20columns%20and%20rows.%26nbsp%3B%20I%20want%20to%20use%20this%20one%20page%20form%20to%20document%20specific%20data%20for%20a%20given%20day.%26nbsp%3B%20I%20know%20that%20it%20can%20be%20done%20because%20there%20are%20calendars%20and%20specific%20charts%20and%20sheets%20that%20I%20can%20select%20from%2C%20but%20I%20want%20to%20design%20one%20specifically%20for%20my%20tasks.%26nbsp%3B%20Is%20there%20a%20way%20to%20do%20that%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386372%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386372%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306956%22%20target%3D%22_blank%22%3E%40Evolushunn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20select%20a%20column%2C%20then%20Ctrl%2BShift%2BRightArrow%20to%20select%20columns%20to%20the%20right.%3C%2FP%3E%3CP%3EFinally%2C%20right-click%20the%20heading%20and%20select%20'Hide'%20from%20the%20dropdown%20menu.%3C%2FP%3E%3CP%3EIf%20anyone%20has%20a%20slicker%20method%2C%20I%20would%20be%20interested%20to%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemoving%20the%20grid%20by%20unchecking%20it%20on%20the%20View%20ribbon%20tab%20also%20improves%20the%20visual%20appearance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614122%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614122%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306956%22%20target%3D%22_blank%22%3E%40Evolushunn%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EI%20am%20trying%20to%20create%20a%20single%20one%20page%20document%20in%20Excel%20without%20all%20the%20extra%20unused%20columns%20and%20rows.%26nbsp%3B%20I%20want%20to%20use%20this%20one%20page%20form%20to%20document%20specific%20data%20for%20a%20given%20day.%26nbsp%3B%20I%20know%20that%20it%20can%20be%20done%20because%20there%20are%20calendars%20and%20specific%20charts%20and%20sheets%20that%20I%20can%20select%20from%2C%20but%20I%20want%20to%20design%20one%20specifically%20for%20my%20tasks.%26nbsp%3B%20Is%20there%20a%20way%20to%20do%20that%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306956%22%20target%3D%22_blank%22%3E%40Evolushunn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614123%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614124%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3BThank%20you%20Pete.%20I%20appreciate%20your%20help%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306956%22%20target%3D%22_blank%22%3E%40Evolushunn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20select%20a%20column%2C%20then%20Ctrl%2BShift%2BRightArrow%20to%20select%20columns%20to%20the%20right.%3C%2FP%3E%3CP%3EFinally%2C%20right-click%20the%20heading%20and%20select%20'Hide'%20from%20the%20dropdown%20menu.%3C%2FP%3E%3CP%3EIf%20anyone%20has%20a%20slicker%20method%2C%20I%20would%20be%20interested%20to%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemoving%20the%20grid%20by%20unchecking%20it%20on%20the%20View%20ribbon%20tab%20also%20improves%20the%20visual%20appearance.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614133%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20unused%20rows%20and%20columns%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306956%22%20target%3D%22_blank%22%3E%40Evolushunn%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344675%22%20target%3D%22_blank%22%3E%40Lonnie82%3C%2FA%3E%26nbsp%3BMost%20templates%20simply%20turn%20off%20the%20grid%20lines%20and%20headings%20from%20the%20Page%20Layout%20%2F%20Sheet%20Options%20menu%2C%20which%20effectively%20hides%20the%20cells%20visually%20but%20they%20still%20exist%20in%20the%20sheet.%26nbsp%3B%20You%20can%20also%20lock%20the%20sheet%20with%20a%20password%2C%20and%20specify%20one%20or%20more%20areas%20that%20are%20still%20editable%20even%20when%20the%20sheet%20is%20locked%20by%20the%20password%20which%20essentially%20confines%20changes%20to%20your%20selected%20areas.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Evolushunn
Occasional Visitor

I am trying to create a single one page document in Excel without all the extra unused columns and rows.  I want to use this one page form to document specific data for a given day.  I know that it can be done because there are calendars and specific charts and sheets that I can select from, but I want to design one specifically for my tasks.  Is there a way to do that?  

5 Replies
Highlighted

@Evolushunn 

If you select a column, then Ctrl+Shift+RightArrow to select columns to the right.

Finally, right-click the heading and select 'Hide' from the dropdown menu.

If anyone has a slicker method, I would be interested to know.

 

Removing the grid by unchecking it on the View ribbon tab also improves the visual appearance.

 


@Evolushunn wrote:

I am trying to create a single one page document in Excel without all the extra unused columns and rows.  I want to use this one page form to document specific data for a given day.  I know that it can be done because there are calendars and specific charts and sheets that I can select from, but I want to design one specifically for my tasks.  Is there a way to do that?  


@Evolushunn 

@Peter Bartholomew Thank you Pete. I appreciate your help


@Peter Bartholomew wrote:

@Evolushunn 

If you select a column, then Ctrl+Shift+RightArrow to select columns to the right.

Finally, right-click the heading and select 'Hide' from the dropdown menu.

If anyone has a slicker method, I would be interested to know.

 

Removing the grid by unchecking it on the View ribbon tab also improves the visual appearance.


 

@Evolushunn @Peter Bartholomew @Lonnie82 Most templates simply turn off the grid lines and headings from the Page Layout / Sheet Options menu, which effectively hides the cells visually but they still exist in the sheet.  You can also lock the sheet with a password, and specify one or more areas that are still editable even when the sheet is locked by the password which essentially confines changes to your selected areas.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies