This tutorial will demonstrate how to delete infinite rows and columns in Excel and Google Sheets.
Delete Infinite Rows
- To select all rows under the data range, select the first row under data and press CTRL + SHIFT + Down Arrow.
After this, all rows will be selected.
- To delete them, right-click on any of them, and from the drop-down menu choose Delete.
As a result, all excess rows are deleted.
Delete Infinite Columns
- To select all columns to the right of the data range, select the first column next to the data and press CTRL + SHIFT + Right Arrow.
After this step, all the columns will be selected.
- Now, (1) right-click anywhere on a selected part of the sheet and (2) choose Delete.
As a result, all the excess columns will be deleted.