Forum Discussion
Maneshb
May 15, 2019Copper Contributor
Delete Excess columns and rows
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 no...
Damien_Rosario
Silver Contributor
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
stephenfrench
Apr 28, 2022Copper Contributor
As of April 2022, i see a delete button, is this a new feature relative to this question?
- SergeiBaklanApr 28, 2022MVP
Not sure which button you mean, but nope - we can't change sheet dimensions, we may only to hide unused rows and columns.