Ask Your Question

the row's height is not correct

asked 2015-06-06 11:20:58 +0200

lolax gravatar image

updated 2015-08-25 19:18:12 +0200

Alex Kemp gravatar image

I selected all cells on a worksheet by clicking the gray box beside column A, then adjusted row's height and column's width, then I inserted a new row from row 1 and found the height of the new row was not correct, since it still used the original height.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-06-06 12:44:21 +0200

pierre-yves samyn gravatar image


As for your other question the default height depends on the font size defined for the Default cell style.

  1. Display the style window (Sidebar or menu Format or F11)
  2. Display the Cell Styles (default display)
  3. Right click Default Modify


edit flag offensive delete link more


This issue I think that it might not use the default cell style to solve. Since I also did a testing, it's that If I only adjusted the height for row 2, then I tested two scenarios (1). inserted a new row from row 2, then the new line has the defult height for the new line. (2). inserted a new row from row 3, then the new line has the new height. Adjusting a certain column's width also has the same issue.

lolax gravatar imagelolax ( 2015-06-08 03:08:54 +0200 )edit

answered 2015-06-06 12:48:47 +0200

m.a.riosv gravatar image

It's how it works, but you can insert a copy of column(s)/row(s) by:

Select a column(s)/row(s), Ctrl+Alt and without release the keys drag the column(s)/row(s) with the mouse where you like.

edit flag offensive delete link more


Thanks, and actually it's a blank worksheet, this issue only exists in adding new row from row one, and adding new column from column one doesn't have this problem. I also tested this situation from ms excel and it doesn't have this issue.

lolax gravatar imagelolax ( 2015-06-06 17:16:48 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-06 11:20:58 +0200

Seen: 228 times

Last updated: Jun 06 '15