Forum Discussion
How do you reduce the number of rows and columns in Excel
I have an excel file that is too large to move around (the screen freezes consistently) There is 1048576 rows and columns to XFD I would like to remove some columns and rows to see if this has an e...
Something that has worked for me on occasion is to select a row using the headings to the left and then Ctrl/Shift/Down to select the bottom of the sheet. Then Cells/DeleteSheetRows to ensure they are empty. Do the same with columns if needed. The saving the file and reopening it should sort any Used Range problems. The vertical ruler should then align with your data.
It worked for me! Many thanks!