+ Reply to Thread
Results 1 to 5 of 5

Formatting problem in automatic table

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    Strasbourg, France
    MS-Off Ver
    2010
    Posts
    28

    Question Formatting problem in automatic table

    Hello to all,

    I hope you are well, I am asking for help because I have been stagnating for a while on a formatting problem.

    I have created a table format in Excel so that the rows are automatically added as soon as I enter a new data in a new row below.

    The problem is that in the "column 3" the font does not use the 16 size calibri but uses a 16 size verdana font.

    I have a workbook with a lot of tabs where I often add rows and the "reproduce formatting" button is getting tired lol.

    If you have any solutions I'm interested, the workbook is attached to my request.

    Thank you in advance and good luck!

    Benten667
    Attached Files Attached Files
    Last edited by Benten667; 11-28-2022 at 03:22 AM.

  2. #2
    Registered User
    Join Date
    01-20-2020
    Location
    Gridley, ILL
    MS-Off Ver
    2021
    Posts
    28

    Re: Formatting problem in automatic table

    Try selecting the table column3 and set to calibri.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Formatting problem in automatic table

    To ensure the correct area of the column is selected, hover your mouse pointer over the top of the header until the cellpointer turns into a black down arrow, then left-mouse-click to select the range. Any format you apply to this area should then stick.

    WhatsApp Image 2022-11-26 at 10.13.06 AM.jpeg

  4. #4
    Registered User
    Join Date
    05-27-2021
    Location
    Strasbourg, France
    MS-Off Ver
    2010
    Posts
    28

    Re: Formatting problem in automatic table

    Hello,

    Thanks for your answers it works, I tried to look too far from the final solution.

    Have a great day!

    Benten667

  5. #5
    Registered User
    Join Date
    11-14-2022
    Location
    Canada
    MS-Off Ver
    Office 95 (7.0)
    Posts
    8

    Re: Formatting problem in automatic table

    Great! Thanks for your answers.

+ 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. Table formatting/numbering problem
    By HJII in forum Excel General
    Replies: 2
    Last Post: 01-21-2013, 03:26 AM
  2. Word Table Formatting problem
    By pangs76 in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2012, 08:55 AM
  3. Excel 2007 : Pivot Table Formatting problem
    By rraze in forum Excel General
    Replies: 0
    Last Post: 07-25-2011, 05:38 AM
  4. Replies: 0
    Last Post: 04-17-2010, 11:21 AM
  5. Pivot table formatting problem
    By ScubaBum via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2006, 03:00 PM
  6. Pivot Table Problem with Formatting
    By Kathleen Bell in forum Excel General
    Replies: 1
    Last Post: 12-13-2005, 09:50 AM
  7. [SOLVED] Automatic formatting problem in Excel
    By Hook in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2005, 04:06 PM

Tags for this Thread

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