Prevent changing font using drag

[KentBurel]

I have a spreadsheet, a portion of which looks like this:

Columns MNO are all in the Wingdings font. Column P is regular ole Calibri. All the cells in column P have a validation formula that the values can only be 0 or ?. The sheet is protected. As you see Format Cells is greyed out. But you see the first row in column P has been changed to the Wingdings font. This happened when the user select the cell in O4 and dragged it to P4. How do I prevent the font in column P from being changed?

 

[sijpie]

Is it OK to have macro's in the workbook?

In the code for this sheet you can check for changes to column P and then set the font for P to Calibri.
To do this, right click on the sheet tab and select View code... The VBA editor will open

Then paste the following code in the window that opens:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Columns("P")) Is Nothing Then
        Columns("P").Font.Name = "calibri"
        
    End If
End Sub

Close the VBA editor.
Now save the workbook as .xlsm (macro enabled)

Then copy something across from O and you will see the font in P changes back to calibri

 

[GabrielHumus]

I may misunderstand your question, if so sorry.
Each font has a different size. When you change font you will ALWAYS change the size needed for the text, so it may get bigger or smaller, or be cut off or flow to a new line, according to the app you are using and the settings.

Are you hoping that Photoshop will change the font and adjust the size so it is the same width on screen? That's just not what happens.