# Character fit within merged cells in Excel **URL:** \ **Category:** General Font Discussions\ **Created:** [March 12, 2018, 6:11am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066 "2018-03-12T06:11:49Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 12, 2018, 6:11am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/1 "2018-03-12T06:11:49Z")
I am working on this font and have noticed that some of the end characters do not within the merged cells in Excel. In the case I have attached, part of some characters are truncated on the right boundary (the green line is the border of merged cells in Excel). Sometimes I have issue where the characters over-run the border rather than continuing in the next line. I have also noticed this latter problem with some fonts I have installed from font manufacturers. Note: The caption is from a printed PDF, not a screenshot in Excel. How can i fix it? ![Untitled.png](https://forum.high-logic.com/uploads/default/original/2X/b/b5c117e32d9ba8a2e63401713d28f3b77697f63d.png) ---
**Author:** ![Bhikkhu\_Pesala](https://forum.high-logic.com/user_avatar/forum.high-logic.com/bhikkhu_pesala/32/9411_2.png) [@Bhikkhu\_Pesala](https://forum.high-logic.com/u/Bhikkhu_Pesala)\ **Post date:** [March 12, 2018, 6:16am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/2 "2018-03-12T06:16:21Z")
This looks like a problem in Excel rather than in the fonts. Try setting the cell padding or margins to a few more pixels. I don’t use Excel, so I cannot tell you how to do that. ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 12, 2018, 6:45am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/3 "2018-03-12T06:45:51Z")
No I don’t believe it is an issue in Excel. It is the font as I have tested hundreds of different types of fonts and the issue seems to be with the less established fonts, rather than with, say, fonts shipped with Microsoft products. ---
**Author:** ![ErwinDenissen](https://forum.high-logic.com/user_avatar/forum.high-logic.com/erwindenissen/32/9430_2.png) [@ErwinDenissen](https://forum.high-logic.com/u/ErwinDenissen)\ **Post date:** [March 12, 2018, 10:52am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/4 "2018-03-12T10:52:10Z")
I’m not able to reproduce the issue with Excel 1802 (from Office 365). ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 12, 2018, 1:55pm UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/5 "2018-03-12T13:55:36Z")
What font are you using? If it’s your own font, is it based on a template from and established font? ---
**Author:** ![ErwinDenissen](https://forum.high-logic.com/user_avatar/forum.high-logic.com/erwindenissen/32/9430_2.png) [@ErwinDenissen](https://forum.high-logic.com/u/ErwinDenissen)\ **Post date:** [March 12, 2018, 1:59pm UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/6 "2018-03-12T13:59:02Z")
I went through all my installed fonts. If you also use the same Excel version, then send me a sample Excel document along with the font. ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 12, 2018, 2:08pm UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/7 "2018-03-12T14:08:17Z")
Erwin I presume all your installed fonts are those provided by Microsoft. In which case this is what I’m trying to say in the original post, the issue is not there not there with the established fonts. With my own font, started from a blank template, I am having issues. And I also note the same issue with some downloaded fonts from sites such as dafont and others. Possibly because of designer inexperience, the characters are either truncated or they over-run the border. ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 13, 2018, 1:34am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/8 "2018-03-13T01:34:44Z")
To illustrate the issue. Compare Courier New with PT Mono. Courier New is an established Microsoft font. PT Mono has the same issue as my font. Attached: - Excel workbook. - PDF printouts. - PT Mono font file. [PTM55FT.ttf](https://forum.high-logic.com/uploads/short-url/54d1c9vnHYmj3zWXlMDVOokpo19.ttf) (182 KB) [PDF - PT Mono.pdf](https://forum.high-logic.com/uploads/short-url/iQyabgX4kKTmGIhpXHDtAc0hoS6.pdf) (20.9 KB) [PDF - Courier New.pdf](https://forum.high-logic.com/uploads/short-url/hag1ZntWy9n8AkCxth4JgoYkHc5.pdf) (17.6 KB) [Excel.xlsx](https://forum.high-logic.com/uploads/short-url/991oHQL3vN8mISUTz2rjxy8aQQ7.xlsx) (14.7 KB) ---
**Author:** ![ErwinDenissen](https://forum.high-logic.com/user_avatar/forum.high-logic.com/erwindenissen/32/9430_2.png) [@ErwinDenissen](https://forum.high-logic.com/u/ErwinDenissen)\ **Post date:** [March 13, 2018, 7:38am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/9 "2018-03-13T07:38:10Z")
Again, no issues here. ![ptmono.png](https://forum.high-logic.com/uploads/default/original/2X/4/45a84f61d2659dc1373b1379ab61f74a86312aba.png) ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 13, 2018, 8:32am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/10 "2018-03-13T08:32:22Z")
Erwin As stated in the original post, the issue is in the printed PDF. You know that Excel will give variable graphic output. Look, I know that it is a difficult and unique issue, and you may not be able to solve it. If you can’t solve upon considering above, please refer me to any literature or another forum that would deal with this. Please don’t take it as criticism, I really have to solve this. ---
**Author:** ![ErwinDenissen](https://forum.high-logic.com/user_avatar/forum.high-logic.com/erwindenissen/32/9430_2.png) [@ErwinDenissen](https://forum.high-logic.com/u/ErwinDenissen)\ **Post date:** [March 13, 2018, 8:44am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/11 "2018-03-13T08:44:29Z")
To me it was not obvious it was a PDF issue. If the fonts do look fine in Excel, then I suspect your PDF generator/driver is the cause of the problem. ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 13, 2018, 8:56am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/12 "2018-03-13T08:56:25Z")
Well done! I think you may be right. Thanks. ---
**Author:** ![Bhikkhu\_Pesala](https://forum.high-logic.com/user_avatar/forum.high-logic.com/bhikkhu_pesala/32/9411_2.png) [@Bhikkhu\_Pesala](https://forum.high-logic.com/u/Bhikkhu_Pesala)\ **Post date:** [March 13, 2018, 11:02am UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/13 "2018-03-13T11:02:58Z")
Topic moved since it is not related to the use of FontCreator. I find that CutePDF is one of the best free PDF printers. Which were you using? ---
**Author:** ![Fonts](https://forum.high-logic.com/letter_avatar_proxy/v4/letter/f/48db29/32.png) [@Fonts](https://forum.high-logic.com/u/Fonts)\ **Post date:** [March 13, 2018, 1:56pm UTC](https://forum.high-logic.com/t/character-fit-within-merged-cells-in-excel/6066/14 "2018-03-13T13:56:11Z")
I was using PDFill. I did try CutePDF but there was no improvement. I printed to xps and this was better but I haven’t found any suitable PDF printer.