Select the row or rows you want to adjust. To select a single row, click the row number. To select a group of rows and drag your mouse over the row numbers.To select all of the rows, click the triangle in the upper left corner of the worksheet.tep 2. Select the Home tab, click Format on the ribbon, and then select Row Height.. You can also right-click the selected rows and choose Row Height from the context menu.
Step 1: Open your spreadsheet in Excel 2010. Step 2: Click the number to the left of the first row whose height you want to change, then drag your mouse down to select the rest of the rows. Step 3: Right-click one of the selected rows, then click the Row Height option. Step 4: Enter a value into the Row height field, then click the OK button.  Change the row height to fit the contents. Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Tip To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings. Match the column width to another column. Select a cell in the column that has the width that you want to use. On the Home tab, in the Clipboard group, click Copy. Keyboard shortcut You can also select a cell in the column that has the width you want to use, and then press CTRL+C. Set a row to a specific height. Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Row Height. In the Row height box, type the value that you want. Match the column width to another column. Select a cell in the column that has the width that you want to use. On the Home tab, in the Clipboard group, click Copy. Keyboard shortcut You can also select a cell in the column that has the width you want to use, and then press CTRL+C. Adjusting width and height automatically. If several columns or rows in your table need to be adjusted to accommodate your data, Excel can automatically adjust the spreadsheet. Select all of the columns or all of the rows that contain your data. Then, hover over the border until your arrow becomes a double arrow. Double click on the border, and all of the rows or columns will automatically adjust to fit the data. To adjust an entire worksheet with both rows and columns, type Control A to select the entire worksheet. Then, double click with a double arrow on any column or row border. Change Height Measurement. Select the row or rows you want to adjust. To select a single row, click the row number. To select a group of rows and drag your mouse over the row numbers. To select all of the rows, click the triangle in the upper left corner of the worksheet. Step 2. Select the Home tab, click Format on the ribbon, and then select Row Height.. You can also right-click the selected rows and choose Row Height from the context menu. Related Reading: How to Format a Row Based on the Value of a Cell in Excel 2007. Step 3 Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Tip To quickly autofit all columns on the worksheet, click the Select All button and then double-click any boundary between two column headings. Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Column Width. In the Column width box, type the value that you want. Change the column width to automatically fit the contents (auto fit). Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Match the column width to another column. Select a cell in the column that has the width that you want to use. On the Home tab, in the Clipboard group, click Copy. Keyboard shortcut You can also select a cell in the column that has the width you want to use, and then press CTRL+C. Set a row to a specific height. Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Row Height. In the Row height box, type the value that you want. Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Column Width. In the Column width Change the row height to fit the contents. Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Column Width. In the Column width box, type the value that you want.
http://www.solveyourtech.com/how-to-change-the-row-height-for-multiple-rows-in-excel-2010/ https://support.office.com/en-us/article/change-the-column-width-and-row-height-515116a6-ca55-4bdf-abe9-363e53e0ff0a https://support.office.com/en-us/article/change-the-column-width-and-row-height-515116a6-ca55-4bdf-abe9-363e53e0ff0a http://www.mcstech.net/blog/index.cfm/2012/1/31/Resizing-Rows-and-Columns-in-Excel http://smallbusiness.chron.com/adjust-row-height-measurement-microsoft-excel-75038.html https://support.office.com/en-us/article/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46 https://support.office.com/en-us/article/change-the-column-width-and-row-height-515116a6-ca55-4bdf-abe9-363e53e0ff0a https://support.office.com/en-us/article/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46 https://support.office.com/en-us/article/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46
how to adjust row height in excel at once