863 votes165 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!
> I seriously cannot understand why this isn't the default. Can you imagine if Word had this behavior default?
To be fair, Word documents that need to reference each other in a live manner aren't really a thing. Excel workbooks can — and frequently do — pull data from each other. So having a global undo is something that would be terrible to be without *IF YOU NEED IT*.
But the fact is, it's a pro feature. It's not needed by the vast, vast, vast majority of users.
The behavior should be an easily-set user preference.
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.
When you're inside the Formula Bar, you can F4 (Windows) or CMD+T (Mac) to toggle between relative, absolute, and mixed.
7 votes4 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion. We’ll consider it along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!
John [MS XL]
This absolutely (pardon me) needs to happen. I'm in the middle of editing dozens of cells one at a time because this very obvious functionality doesn't exist.
Also, apparently it's impossible to toggle between relative and absolute except via keyboard shortcut — no Menu item, no Ribbon button. Seriously?
38 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.