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
- 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).
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
