Home

Deleting unwanted rows and columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1176270%22%20slang%3D%22en-US%22%3EDeleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176270%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20someone%20please%20tell%20me%20the%20simplest%20way%20to%20delete%20the%20unwanted%20rows%20and%20columns%20at%20the%20end%20of%20spreadsheets%20and%20just%20to%20save%20the%20the%20ones%20I%20need%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176270%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176349%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176349%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559574%22%20target%3D%22_blank%22%3E%40chipg900%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20several%20ways%20to%20remove%20unwanted%20rows%20and%20columns%20in%20excel.%20The%20method%20that%20you%20choose%20may%20depend%20on%20what%20rows%20and%20columns%20you%20wish%20to%20remove.%20Here%20are%20a%20few%20ways%20to%20remove%20rows%20and%20columns%20in%20excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ERight-click%20a%20row%20number%20or%20column%20letter%20in%20the%20rows%2Fcolumns%20bar.%20Select%20delete.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1581875863860.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171441iFD538174A6765217%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PReagan_0-1581875863860.png%22%20alt%3D%22PReagan_0-1581875863860.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3ESelect%20a%20row%2Fcolumn%20that%20you%20would%20like%20to%20remove.%20Go%20to%20the%20Home%20tab%2C%20under%20%22Cells%22%20select%20%22Delete%22.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_1-1581876087959.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171442iC157109B37CB124A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PReagan_1-1581876087959.png%22%20alt%3D%22PReagan_1-1581876087959.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3ESelect%20a%20row%2Fcolumn%20that%20you%20would%20like%20to%20remove.%20Press%20Ctrl%2B%22-%22.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176376%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176376%22%20slang%3D%22en-US%22%3EI've%20a%20similar%20question%2C%20only%20it%20doesn't%20involve%20deleting%20data%20(rows%20or%20columns)%2C%20but%20deleting%20whatever%20I%20need%20to%20to%20reset%20the%20the%20location%20of%20'Cntrl-End'.%20I'd%20like%20to%20go%20to%20the%20end%20of%20my%20working%20area%2C%20not%20the%20last%20cell%20touched%20that%20is%20farthest%20away%20from%20A1.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176387%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176387%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535078%22%20target%3D%22_blank%22%3E%40JBF_54%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20this%20answers%20your%20question%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flocate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flocate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176652%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176652%22%20slang%3D%22en-US%22%3EThe%20article%20you%20pointed%20me%20to%20is%20exactly%20what%20I%20was%20after%20...%20However%2C%20after%20following%20the%20steps%20described%20in%20the%20article%2C%20my%20spreadsheet%20ballooned%20from%203700KB%20to%2046%2C000KB%2C%20with%20no%20change%20in%20the%20location%20of%20Cntrl-END.%3CBR%20%2F%3E%3CBR%20%2F%3EHelp!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176969%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176969%22%20slang%3D%22en-US%22%3EUpdate%3A%20I%20repeated%20the%20procedure%2C%20this%20time%20adding%20the%20steps%20of%20deleting%20the%20unused%20rows%20and%20columns%2C%20then%20exiting.%20This%20shrunk%20the%20file%20down%20to%20its%20original%20size%2C%20but%20still%20hasn't%20moved%20the%20Cntrl-End%20location.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177573%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535078%22%20target%3D%22_blank%22%3E%40JBF_54%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20share%20a%20sample%20file%20so%20that%20I%20can%20facilitate%20testing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177840%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177840%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20send%20you%20the%20file%20without%20it%20being%20posted%20for%20the%20whole%20world%20to%20see%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177873%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177873%22%20slang%3D%22en-US%22%3EI%20would%20recommend%20removing%20any%20sensitive%20information%20or%20replacing%20it%20with%20dummy%20data%20and%20attaching%20it%20as%20a%20reply%20to%20this%20thread.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177886%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20deleted%20all%20tabs%20except%20the%20one%20of%20concern.%20That%20generated%20some%20%23REF!%20errors%20that%20can%20be%20ignored%20with%20respect%20to%20the%20Cntrl-End%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178273%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535078%22%20target%3D%22_blank%22%3E%40JBF_54%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20some%20reason%2C%20copying%20and%20pasting%20the%20data%20into%20a%20new%20tab%20resets%20the%20last%20used%20cell.%20To%20do%20this%3A%3C%2FP%3E%3COL%3E%3CLI%3EStart%20in%20cell%20A1%3C%2FLI%3E%3CLI%3EPress%20Ctrl%2BShift%2BRight%20Arrow%2BDown%20Arrow%3C%2FLI%3E%3CLI%3ECtrl%20%2B%20C%3C%2FLI%3E%3CLI%3EInsert%20a%20new%20worksheet%20and%20Ctrl%20%2B%20P%20to%20paste%20data%20starting%20in%20cell%20A1%3C%2FLI%3E%3CLI%3EPress%20Ctrl%20%2B%20End%20to%20ensure%20that%20this%20takes%20you%20to%20the%20last%20used%20cell%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178339%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178339%22%20slang%3D%22en-US%22%3EBut%20won't%20that%20break%20all%20the%20formula%20on%20the%20other%20sheets%20(which%20were%20deleted%20to%20send%20you%20the%20sample%20data)%20that%20refer%20to%20the%20existing%20tab%20and%20table%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178506%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559574%22%20target%3D%22_blank%22%3E%40chipg900%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20Inquire%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FClean-excess-cell-formatting-on-a-worksheet-E744C248-6925-4E77-9D49-4874F7474738%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FClean-excess-cell-formatting-on-a-worksheet-E744C248-6925-4E77-9D49-4874F7474738%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178533%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20unwanted%20rows%20and%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178533%22%20slang%3D%22en-US%22%3EThanks%20...%20I%20followed%20the%20instructions%20in%20the%20article%2C%20but%20there%20is%20no%20%22Inquire%22%20options%20under%20COM%20Add-Ins.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Could someone please tell me the simplest way to delete the unwanted rows and columns at the end of spreadsheets and just to save the the ones I need? Thank you.

13 Replies
Highlighted

Hello @chipg900,

 

There are several ways to remove unwanted rows and columns in excel. The method that you choose may depend on what rows and columns you wish to remove. Here are a few ways to remove rows and columns in excel:

 

  1. Right-click a row number or column letter in the rows/columns bar. Select delete.
    PReagan_0-1581875863860.png
  2. Select a row/column that you would like to remove. Go to the Home tab, under "Cells" select "Delete".
    PReagan_1-1581876087959.png
  3. Select a row/column that you would like to remove. Press Ctrl+"-".
Highlighted
I've a similar question, only it doesn't involve deleting data (rows or columns), but deleting whatever I need to to reset the the location of 'Cntrl-End'. I'd like to go to the end of my working area, not the last cell touched that is farthest away from A1.
Highlighted
Highlighted
The article you pointed me to is exactly what I was after ... However, after following the steps described in the article, my spreadsheet ballooned from 3700KB to 46,000KB, with no change in the location of Cntrl-END.

Help!
Highlighted
Update: I repeated the procedure, this time adding the steps of deleting the unused rows and columns, then exiting. This shrunk the file down to its original size, but still hasn't moved the Cntrl-End location.
Highlighted

@JBF_54 

 

Can you please share a sample file so that I can facilitate testing?

Highlighted
Is there a way to send you the file without it being posted for the whole world to see?
Highlighted
I would recommend removing any sensitive information or replacing it with dummy data and attaching it as a reply to this thread.
Highlighted

@PReagan 

 

I deleted all tabs except the one of concern. That generated some #REF! errors that can be ignored with respect to the Cntrl-End problem.

 

Thanks ...

 

Highlighted

@JBF_54 

 

For some reason, copying and pasting the data into a new tab resets the last used cell. To do this:

  1. Start in cell A1
  2. Press Ctrl+Shift+Right Arrow+Down Arrow
  3. Ctrl + C
  4. Insert a new worksheet and Ctrl + P to paste data starting in cell A1
  5. Press Ctrl + End to ensure that this takes you to the last used cell
Highlighted
But won't that break all the formula on the other sheets (which were deleted to send you the sample data) that refer to the existing tab and table?
Highlighted
Thanks ... I followed the instructions in the article, but there is no "Inquire" options under COM Add-Ins.