Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel file too big to allow additional data, even when 99% of cols/rows are empty. No help text

Copper Contributor

If a file is too big (i.e. accidentally created file of maximum size, so you can't delete unnecessary empty columns/rows) how are you enabled to add in additional rows of new information?  I can't find the right words to access Excel help on this.

1 Reply
Hard to diagnose and treat without a more complete description of what you did to create file of max size, what those supposedly empty cells contain.
You might be able to highlight a lot of the existing rows and columns--the ones you don't really need--and use "Edit...Clear....All"