in the Cells group, click on the Format option.Select all the rows by clicking and dragging on the row headers (or select the cells in a column for all the rows for which you want to change the height).Let’s say you have a data set as shown below and you want to increase the row height of all the rows in the data set. You can specify the exact row height you want for a row (or multiple rows). You can also do this for a range of cells.įor example, if you have multiple cells and you need to at just the row height for all the cells, select the row header for these cells and double click on the edge of any of the rows.
When you double-click the mouse key, it automatically expands or contracts the row height to make sure that it is enough to display all the text within the cell.
You will notice that the cursor would change into a plus icon
Place the cursor at the bottom edge of the row header for which you want to change the height.Suppose you have a data set as shown below, and you want to change the row height of the third row (so that the entire text is visible in the row).īelow are the steps to use the mouse to change the row height in Excel: The easiest and the most popular method to change row height in Excel is to use the mouse. Can We Change the Default Row Height in Excel?Ĭhange the Row Height with Click and Drag (Using the Mouse).Keyboard Shortcut To Specify the Row Height.Change the Row Height with Click and Drag (Using the Mouse).Is there a way to do this? (I'm an Access developer, not especially expert in Word). I also tried it with the Shift key, then the Control key, held down still no luck. If I try the same thing with the any combination of those few cells selected, again, that whole row is affected. I need to re-size the rows in the area in the red rectangle to match the same area on the 1099 in that 3 x2 grid (boxes "5" through "9b"), I need to reduce the height of the bottom row of cells, and raise the height of the upper 2 rows.īut when I click & hold on the column border between the 2nd & 3rd row and drag it down, it drags down across the whole table.
Now I'm running into trouble trying to re-size rows in a particular area (please see attached image file). I laid out a table that had enough rows & columns to where I could get close to the actual cells on the 1099 by Split'ing & Merge'ing Cells in the Word table. Hello - I'm trying to create a facsimile of the IRS 1099-R form in a Word docx (Word 365), to use in Mail Merge.