My Excel row is locked at height of 409.5 and I want to increase the size

excel formatting height row
GarrettForce picture GarrettForce · Feb 10, 2014 · Viewed 49.9k times · Source

The height for one of my rows in excel maxes out at 409.5 and I need to increase the height. Where/how can I fix this.

Answer

jtchase08 picture jtchase08 · Apr 23, 2018

1) Create a row below the row you want taller than 409.5

2) Select cell of top row, and cell of bottom row

3) Click arrow next to the Merge & Center button in the Alignment section of the Home tab on the ribbon

4) Click Merge Cells

You can repeat this process multiple times if two cells worth of height isn't enough.

Related questions

Excel CSV - Number cell format

I produce a report as an CSV file. When I try to open the file in Excel, it makes an assumption about the data type based on the contents of the cell, and reformats it accordingly. For example, if the …

Read More
(Excel) Conditional Formatting based on Adjacent Cell Value

I'm trying to apply conditional formatting in Excel on a range of cells, based on the adjacent cell's value, to achieve something like this: The goal is to highlight values in Column B (Actual Expense) red if the value is …

Read More
Ordering issue with date values when creating pivot tables

I have a 2-column spreadsheet which contains Dates and Sales figures as follows: When doing Right click -> Format Cells the values in the Dates column properly appear as Date (in the M/D/YYYY format). This applies to …

Read More