Forum Discussion

Doug_Bailey's avatar
Doug_Bailey
Copper Contributor
Nov 26, 2021

Auto Cell Formatting

I am using Excel 2019. Row 2 has a certain format in colors and strikeout. When I enter anything on row 3, directly below, the format carries over, color and strikeout. How do I turn of the auto formatting?

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 28, 2021

    Doug_Bailey 

    Excel -> File -> Options -> Advanced ->

    -->Editing Options - Expand data range formats and formulas,

    -->remove the check mark.

    Click OK.

     

    Additional Informations: Advanced options

     

    This setting is possible from version 2007 and should also be possible with Excel 2019.

    Tried it with Excel 2016 and works without problems :).

     

    I would be happy to know if I could help.

     

    NikolinoDE

    I know I don't know anything (Socrates)

    Was the answer useful? Mark them as helpful!

    This will help all forum participants.

Resources