Forum Discussion
Solved
Issues deleting rows & columns beyond the last cell in excel 365
Hi tech community, I'm trying to keep my file size down and my sheets legible by deleting all rows and columns that are beyond the last cell. I've looked online how to do it and, even though I've...
ElRafaVaz You simply can't delete the grid, but you can hide the unused columns and rows. Select all columns F to XFD, right-click, Hide. Do the same for rows 38 to 1048576.
ElRafaVaz You simply can't delete the grid, but you can hide the unused columns and rows. Select all columns F to XFD, right-click, Hide. Do the same for rows 38 to 1048576.
Got it. I thought it would work kind of like sheets where you can make sure that cells are not taking extra resources by deleting unused columns.
I guess in excel I have to do the 'Last Cell check' and hide the rest for legibility. Thanks Riny_van_Eekelen