+ Reply to Thread
Results 1 to 3 of 3

Table Font Sizes

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    SG
    MS-Off Ver
    MS Excel 2019 & 365
    Posts
    241

    Table Font Sizes

    I have a table containing a formula and every time a new row was added, the font size in column E was be changed.
    Any advise?
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,919

    Re: Table Font Sizes

    What you are running into is that a table will copy down all the properties of the cells above it, ONLY if all the cells above it are the same. The first row has a different font from the rest. Make every existing cell Calibri 11 and then new incoming cells will mimic this font.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    02-23-2015
    Location
    SG
    MS-Off Ver
    MS Excel 2019 & 365
    Posts
    241

    Re: Table Font Sizes

    Thanks for your reply.
    I noticed when the font size set at 11, I don't face this issue.
    It only happens when I set all the cells to size 9. and it only happens to column E and not others cell. Column E has a formula and not sure how can it affect the font size.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Font and sizes
    By steven_b46 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2014, 10:33 PM
  2. [SOLVED] issue with row heights & font sizes
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-21-2014, 11:42 PM
  3. two font sizes in chart title
    By penfold1992 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-04-2012, 09:49 AM
  4. Macro to convert several font sizes to another font size - with an exception
    By ddd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-08-2012, 05:17 PM
  5. [SOLVED] Font sizes changes erratically
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2006, 01:10 PM
  6. Smaller Font Sizes ?
    By YorkBeach in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 06:40 PM
  7. [SOLVED] Can you mix font sizes in a cell?
    By Marc in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-11-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1