ANSWERS: 1
  • Excel spreadsheets do have an annoying tendency to grow over time. Fortunately, that's generally simple to correct, too, though it takes a few extra steps: 1. On every worksheet that you want to shrink, locate the bottom right cell to retain in the worksheet. Make sure that there are no hidden rows below or columns to the right of the cell you choose. 2. When certain, highlight all columns to the right and Edit / Delete / Entire column. Do the same with rows beneath: select them, then Edit / Delete / Entire row. 3. Now 'select' the entire range to be retained, worksheet by worksheet, and save the file. (Have the ranges selected as you save.) 4. Close the file, then re-open the version you have just saved. Use the 'End' key (or 'Ctrl-End', depending on how you navigate) to have Excel automatically find what it believes to be the bottom-right cell on each worksheet. It should be the one you had previously selected. If not, go back and repeat steps 1 - 3 above. 5. When Excel recognizes your chosen 'end of sheet' marker, then save the file again, and the next time you open it, it should not have 'extra lines' in it unless something else is operating on it, such as a macro. Hint: It may also be advisable to simply hide all unused rows or columns to the bottom and right of your intended 'end cell'. This does nothing to reduce the file size, but it does prevent Excel from displaying the unwanted rows and columns.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy