Delete Excess columns and rows

Occasional Visitor

I have an excel file with multiple sheets in the workbook. Everyone one of the sheets goes up to column XFD and row 1048576. I have tried to the clear all option, and saved the file after this but nothing changes. I have tried deleting the rows and columns, but they still remain. Any idea how to delete all these Rows and Columns that are useless?

When I add a new sheet to the workbook, it automatically creates a large sheet going up to column XFD and row 1048576.

 

3 Replies

Hi @Maneshb 

 

Try this solution from a previous post to Hide the columns instead.

 

https://techcommunity.microsoft.com/t5/Excel/Need-help-with-Excel/m-p/144356#M3492

 

Hope that does the trick.

 

Cheers

Damien

As of April 2022, i see a delete button, is this a new feature relative to this question?

@stephenfrench 

Not sure which button you mean, but nope - we can't change sheet dimensions, we may only to hide unused rows and columns.