You cannot change the vertical white space without adjusting row height. The question marks in the format forces Excel to leave space as if there were a digit, even if there isn't. The way around this last issue is to still center the contents horizontally, but use a custom number format for the cells, as follows: In addition, your numbers will not line up properly-on the decimal point-if you choose to center horizontally. The drawback to this approach, of course, is that it affects the width of not just one cell, but of the entire column and row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |