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

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