Forum Discussion
Solved
Adding a column
I have just updated to 365 and can't understand why I can't just add a column by pressing Insert. I get the message that I can't do it because it would push non-empty cells off the worksheet. I don't know what this means or how to rectify the problem. The instructions aren
Amand1040 I'm not at all familiar with how Excel file sizes can be calculated, but when you say 366K rows by 283 column, that means your file has over 100 million cells. If these all would contain 1 byte of data, that would already result in a file size of around 100MB. Then, your 140MB isn't all that strange.
Tested this by creation a file with 1 million cells with numbers. Saved it and the file size was 2.9MB. Perhaps my reasoning makes no sense at all, but if performance is an issue, consider connecting to the file with Power Query, rather than opening it in Excel.
2 Replies
- There are non-empty cells in the rightmost column(s) that would get 'pushed off the edge' of the worksheet if you inserted columns. Even if the cells are actually empty, they may contain formatting or excel thinks they are part of the used range.
Try this: select/highlight the entire column of the first empty column to the right of your data. Then, hit Ctrl+Shift+Right Arrow, and Clear/All. Then, save the workbook. This should clear the unused cells and reset the used range (same process can be used for rows).- Thanks a million. It worked.
Don
