Forum Discussion
chipg900
Feb 16, 2020Copper Contributor
Deleting unwanted rows and columns
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.
- PReaganBronze Contributor
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:
- Right-click a row number or column letter in the rows/columns bar. Select delete.
- Select a row/column that you would like to remove. Go to the Home tab, under "Cells" select "Delete".
- Select a row/column that you would like to remove. Press Ctrl+"-".
- Right-click a row number or column letter in the rows/columns bar. Select delete.
- JBF_54Brass ContributorI'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.
- JBF_54Brass ContributorThe 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!
- JBF_54Brass ContributorUpdate: 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.
- JBF_54Brass ContributorThanks ... I followed the instructions in the article, but there is no "Inquire" options under COM Add-Ins.