Jump to content
  • The Excel formula bar now has monospaced font support for Windows Beta Insiders


    Karlston

    • 1 comment
    • 655 views
    • 2 minutes
     Share


    • 1 comment
    • 655 views
    • 2 minutes

    Microsoft is once again adding a feature in its Excel spreadsheet program that it probably should have added a long time ago. Earlier this month it added a way to see stale cells crossed out in manual calculation mode. Today, it's adding an improvement to the app's formula bar.

     

    In a blog post, Microsoft admits that it has been sometimes hard to read and edit characters in the formula bar because some of the formulas could get very complex. Now, a new update for Windows Insiders in the Beta Channel has added support for monospaced font in the formula bar,

     

    What is monospaced font? Microsoft says that this is a type of font where every character has the same width, no matter its shape or style. Microsoft says that the use of a monospaced font in the Excel formula bar "means that your formulas will be aligned and spaced evenly, making them easier to read and debug."

     

    1692376488_monospacedformulaexample_stor

     

    The blog post offers an example of the formula bar using a traditional font, and one which is using a monospaced font. The latter version definitely looks easier to read, and we would imagine it's much easier to work with for Excel formula creators.

     

    In addition to just making formulas easier to read in the Excel formula bar, Microsoft points out a number of other advantages of using a monospaced font.

     

    Monospaced fonts offer consistent alignment, making it easier to quickly spot errors, typos, and discrepancies in code. This uniform spacing enhances visual parsing of complex structures, aiding in identifying patterns, nested levels, and relationships within the logic.

     

    Monospaced fonts offer streamlined copy-pasting of code from different sources while maintaining formatting. They also ensure a uniform appearance across various platforms and editors, guaranteeing consistent readability and structure.

     

    The new features is, as we said, available for Windows Insiders in the Canary channel right now. It will be rolled out to the Windows Excel app first, and other platforms will get the monospaced font support for the formula bar at some point in the future.

     

    Source


    User Feedback

    Recommended Comments

    Good move. Hopefully the sites who post columns of numbers using proportional fonts will also learn to change this ugly rubbish...

     

    $1,111.11

    $8,888.88

     

    (proportional font)

     

    ..to..

     

    $1,111.11

    $8,888.88

     

    (monospaced font)

    Link to comment
    Share on other sites




    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Add a comment...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...