Change row heights in multiple, non-adjacent rows

Anonymous
2022-07-13T19:07:14+00:00

We have a spreadsheet that is an export from Crystal Reports. Between records, the row height is set at "3". Between fields, the row height is set to "1.5".

Is there a way to change all the row heights to another value? So, all "3" row heights would become "5" and all "1.5" would become "5"?

We use O16.

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 No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Anonymous
    2022-07-17T13:31:35+00:00

    Re: "WOW! Two great replies back to back. I'll try yours, Nothing Left to Lose (or should I cal you 'Freedom'?) and yours, Rich~M. The winner gets a cookie from Netscape Bakeries."

    Did you eat all of the cookies?

    '---

    Nothing Left to Lose

    Me & Bobby McGee

    Lyrics: Kris Kristofferson and Fred Foster
    Vocal: Janis Joplin

    0 comments No comments
  2. Anonymous
    2022-07-18T14:15:01+00:00

    Nope. My mouse got to them first.

    0 comments No comments