The user who posted this question has stumbled onto one of the most frustrating, silent time-wasters in traditional spreadsheet software. Changing the indent resets your alignment. Changing the alignment resets your indent. It is a circular trap that makes a simple formatting task feel like a logic puzzle, and it has no good reason to exist. Our take is plain: this isn't a feature limitation, it is a design failure that has persisted for far too long.
What this means for you is that every time you try to make a report look clean, rotating a header to save space while keeping that text slightly indented for readability, you are forced to choose. You can have vertical text, or you can have indented text, but you cannot have both. The software treats these two settings as if they are in conflict, even though they are independent properties. A human reading your spreadsheet doesn't care about the technical reason; they just see a broken layout. So you either waste time manually adjusting each cell, or you give up on the visual clarity you wanted. Neither outcome serves your productivity.
This is exactly the kind of friction that an AI-native approach to spreadsheets should eliminate. When you work with a tool that understands intent rather than just cell coordinates, the system can recognize that you want a 90-degree rotation *and* a left indent of two spaces. It should apply both without negotiation. The problem here is not that the task is technically complex, it is that the software was built around a rigid set of formatting rules that were never designed to talk to each other. Users end up fighting the tool instead of using it.
The fix is not a workaround or a macro. It is a shift in how the software thinks about formatting. If a tool can learn how you structure data and offer intelligent suggestions, it can certainly handle the simple request of "rotate this text and push it in a bit." Until that happens, you will keep hitting this wall. The good news is that you do not have to accept it as inevitable. Explore tools that treat your formatting choices as a whole picture, not as a list of mutually exclusive settings. That is where the real productivity gain lives.