Previous Topic Next Topic

How do I set the height of rows in Excel all at once ?

Closed
xarzu Posts 6 Registration date Sunday August 12, 2012 Status Member Last seen December 16, 2023 - Mar 18, 2023 at 08:48 PM
Aron_7608 Posts 3 Registration date Tuesday December 15, 2020 Status Member Last seen May 15, 2023 - May 15, 2023 at 02:36 AM

Hello,

How do I set the height of rows in Excel all at once instead of doing them one click at a time by clicking and dragging and dropping the indicator on the left side of the Excel UI?


Windows / Chrome 111.0.0.0

Related:

1 response

Answer 1 / 1
Aron_7608 Posts 3 Registration date Tuesday December 15, 2020 Status Member Last seen May 15, 2023
May 15, 2023 at 02:36 AM

Hi, 

There are 2 ways through which you can do it-

  1. Ctrl+A and then set the height of just 1 row. As you have already selected all the rows, just setting the height of 1 row will apply to all the other selected rows.
  2. Select the Rows you want to change the height for and do the same as the 1st method. Set the height of just 1 row and it will change the height of all the selected rows.

If you have any doubts, please let me know.

Best Regards.