See all How-To Articles

Delete Infinite Rows / Columns in Excel & Google Sheets

This tutorial will demonstrate how to delete infinite rows and columns in Excel and Google Sheets.

 

delete infinite rows columns 9

 

Delete Infinite Rows

  1. To select all rows under the data range, select the first row under data and press CTRL + SHIFT + Down Arrow.

 

delete infinite rows columns 3

 

After this, all rows will be selected.

 

delete infinite rows columns 5

 

  1. To delete them, right-click on any of them, and from the drop-down menu choose Delete.

 

delete infinite rows columns 6

 

As a result, all excess rows are deleted.

 

delete infinite rows columns 8

 

Delete Infinite Columns

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

 

delete infinite rows columns 11

 

After this step, all the columns will be selected.

 

delete infinite rows columns 12

 

  1. Now, (1) right-click anywhere on a selected part of the sheet and (2) choose Delete.

 

delete infinite rows columns 13

 

As a result, all the excess columns will be deleted.

 

delete infinite rows columns 14