33 votes8 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
1000%. I can't think of any reason why having merged cells in the row could possibly make any difference.
It's absurd that merging a cell makes it not possible to AutoFit the height. And even if there's a good reason, there's no excuse at all for having AutoFit Row Height available if it can't be used. It should be grayed out, so users at least understand it won't work, even if they don't know why.
But #1, make it possible to AutoFit Row Height regardless of merged cells. I need this badly for cells in which I'm making lists with line breaks within the cell.
816 votes153 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!
John from Excel, how about just giving us another keystroke for "undo in this workbook only"?
CTRL+Z for undo within a workbook (because I'm sure the vast, vast majority of Excel users don't need the cross-workbook undo), and CTRL+ALT+Z for cross-workbook undo.
And on Mac (where I'm working) CMD+Z and CMD+OPT+Z. A person who needs cross-workbook undo can *always* use one, and a person who doesn't can *always* use the other. I think that would solve the problem.
FYI, Tina Ess, if "it never happened before" to you, you've been lucky. This has been a problem since at least 2003.
Here's a SuperUser thread from 2011 where someone is seeking a solution to this problem.
It includes an explanation of why this issue exists and why it's hard for Microsoft to remove it: "MS does this for Excel only due to cross-workbook references. The only way they can maintain integrity of formula relationships in that context is to maintain a single undo history."
In other words, it's vital for anyone who frequently uses a lot of formulas referencing other workbooks. I can understand how that might be the case. But speaking as someone who has never done that and probably never will, the majority of Excel users shouldn't have to pay the price on a regular basis for the sake of a feature used only by super-Excel pros.Rob supported this idea ·
4 votesRob shared this idea ·