banner



How To Change The Row Height On All Rows In Excell

If you are working on a spreadsheet with a lot of rows that contain dissimilar information, it tin can make information technology easier to read if yous change the height of a few rows. But if y'all want to continue things compatible, specially on a spreadsheet that is being printed, some information can get disregarded if it is in betwixt some larger rows. One way to avert this is to fix the summit of multiple rows to the same size. While it can be tedious to do this individually for each row, information technology is possible to set the height of multiple rows at the aforementioned fourth dimension.

Set Multiple Rows to the Aforementioned Acme in Excel 2010

I by and large utilise this trick when I am printing out something that needs to exist written on, such as a checklist. The default row acme in Excel is very small, and is normally difficult for writing. Just if you follow the steps below to make your rows larger, information technology makes for a much handier checklist.

Step ane: Open your spreadsheet in Excel 2010.

Step 2: Click the number to the left of the offset row whose height you lot want to alter, so elevate your mouse downwards to select the balance of the rows.

select the rows for which you want to change the height

Step 3: Correct-click one of the selected rows, and then click the Row Height choice.

select the row height option

Step 4: Enter a value into the Row acme field, then click the OK button.

how to change the height for multiple rows in excel 2010

Your selected rows volition change to the height that you just entered, as in the epitome below.

example of edited row heights

If you've been looking for a new laptop just don't want to go one with Windows 8, there are still a number of practiced options available. Click here to run into a selection of affordable Windows 7 laptops from Amazon.

Learn more than about irresolute row, cavalcade and jail cell sizes in Excel 2010.

solveyourtech.com newsletter

Disclaimer: Almost of the pages on the net include chapter links, including some on this site.

Source: https://www.solveyourtech.com/how-to-change-the-row-height-for-multiple-rows-in-excel-2010/

Posted by: quinnoloplath.blogspot.com

0 Response to "How To Change The Row Height On All Rows In Excell"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel