Feedback by UserVoice

How can we improve Excel for Mac?

AutoFit Row Height for Merged Cells

Long time ask by many...create a button or functionality to AutoFit the row height for merged cells for those that use Excel to create forms, summary reports (based on drop-downs and IF statement). There are all sorts of ways to do this with Macros, some hard, and some easy, but it's so basic and needs to finally exist as an option.

8 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

JLD shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Rob commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base