A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
If you want to hide columns and rows, you should do it in default view. Any hidden columns or rows will be the same as default view when you reopen that file. This is limitation in sheet view.
Maintain hidden rows/columns in "sheet view" so other users are not - Microsoft Community
You may send feedback to Microsoft to fix it.
Excel · Community (microsoft.com)
Send feedback to Microsoft with the Feedback Hub app - Microsoft Support