Delete Infinite Rows / Columns in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on December 4, 2022

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

 

delete infinite rows columns 9

 

If your Excel data has multiple blank rows and/or columns, see How to Delete Blank Rows and How to Delete Blank Columns to help clean up the data.

Sometimes, an Excel worksheet can have “fake” blank rows or columns that aren’t deleted when you use the methods linked above. This might happen, for example, when data is imported from another source into Excel. The existence of fake blanks can add to the size of the file, making it less efficient. Read on for how to deal with infinite extra rows or columns that can come from fake blanks.

Delete Infinite Rows

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

 

delete infinite rows columns 3

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 +  →.

 

delete infinite rows columns 11

delete infinite rows columns 12

 

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

 

delete infinite rows columns 13

 

As a result, all excess columns are deleted.

 

delete infinite rows columns 14

AI Formula Generator

Try for Free

See all How-To Articles