Forum Discussion
Cant push objects off a sheet
To everyone that has this issue, dkyrtata has the correct solution.
It seems that the old style Comments (called NOTES in Office 2019+) that 'span' to the right hand side for instance (hovers over into other columns), those columns are the columns that can't be hidden ("Can't push objects off a sheet").
The problem is my comments are hidden by default (only shows on hover) so I never realized the comments would overlap the target columns that I want to hide.
Manually MOVE the comments (notes) into the column it is showing information for or to the left such that nothing that will 'hover' will be in the overlapping the columns you want to hide (I usually hide everything to the right that is unused).
I imagine everything like the new conversation notes eg. that will 'hover' its contents in overlapping columns that you want to hide will do the same.
It would appear that the 'hidden' section is 'out of bounds' even for Excel to render things.
Thanks for this, I was so confused!
Just in case, we have both Comments and Notes on modern Excel.
In general behaviour is bit different, but that concrete case, yes, that doesn't matter.