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.
PReagan
Feb 16, 2020Bronze 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+"-".