This is a bummer. With the move to office 365, teams and other web based applications, you would think this would have a solution; especially considering that Google Sheets supports this. We're migrating all of our business documents and forms off of Google into Microsoft and are finding these shortcomings all over the place.
@edurshpek Is there a way to suggest this update be made? I am also moving from google sheets to Microsoft and finding that these items may seem small, but have a large impact on an organization as a whole.