Share via

Cannot change row height

Anonymous
2023-02-22T18:28:46+00:00

Excel 2016 using Page Layout view:

  1. Right-click on a row and select Row Height
  2. Replace the current value (0.26") with desired value: 0.3"
  3. Click OK
  4. Observe row height is not changed
  5. Right-click on the row and select Row Height
  6. Confirm Excel discarded user input and the value is still 0.26"
  7. Repeat ad infinitum

**** is going on here?

I can drag the row to my specific height and it accepts that change. I can also switch back to Normal view, enter the corresponding value in pixels (32) and that change is accepted.

But when I use the Page Layout view, the row height dialog no longer works? This is beyond ridiculous.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-22T19:09:07+00:00

    Actually, it's much worse that just not working. Try this:

    1. Open row height dialog
    2. Make no changes whatsoever
    3. Press OK
    4. Observe row height gets decreased by 0.02"
    5. Repeat as many times as you like, until the row is too small to select with the mouse cursor

    Kind of hilarious. What a silly bug to send to production.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-02-23T17:23:40+00:00

    Well I'm glad I had the foresight to record a screen capture (video) which demonstrates this bug. But since you can't post video here I'll have to find somewhere else to upload and link back here.

    Doesn't look like we're using the same version:

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-02-24T07:48:13+00:00

    Dear Patrick,

    Thanks for your updates and kindness.

    It seems that you are using Excel 2016. The screenshots provided above is the test result by using the Excel 365 application in our environment.

    If you have Microsoft 365 applications in your environment, could you mind doing a test with the Excel 365 application and see if it is the issue only existing in Excel 2016 in your environment?

    May I know whether the issue occurred suddenly? If yes, what did you do before the issue happened?

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments
  4. Anonymous
    2023-02-23T04:42:29+00:00

    Dear Patrick,

    Welcome to the forum here.

    I did a test in our environment and it seems that I can't reproduce the issue.

    May I know whether the issue occurred suddenly? If yes, what did you do before the issue happened?

    If it is convenient, please open Excel>click on File>Account and upload a full screenshot of the Account page for our reference.

    Note: Remove any private information before uploading the screenshots.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments