May 15 2019 11:37 AM
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.
May 15 2019 09:36 PM
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
Apr 28 2022 12:08 PM
Apr 28 2022 01:01 PM
Not sure which button you mean, but nope - we can't change sheet dimensions, we may only to hide unused rows and columns.