Forum Discussion

Aomojang's avatar
Aomojang
Copper Contributor
Jan 24, 2023

Font changed while copying in MS Excel 2019

Hi,

 

Sheet A used font Calibri 11pt, and sheet B used the font Calibri 11pt but when I copy data from sheet A to B, it pastes data as font Arial 11pt. I used copy by Ctrl+ C and paste by Ctrl+V. I don't want to paste special. I want to keep the format cell as sheet A, Could you help how to fix it?

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 24, 2023
    Sounds like the standard cell style's Font for B is set to Arial rather than Calibri. in the Cell styles box on the home tab, right-click "Normal" and choose Modify. Set its font to Calibri.
    • Aomojang's avatar
      Aomojang
      Copper Contributor
      Jan 31, 2023

      JKPieterse 

      Hi Jan Karel Pieterse,

      thank you for your idea. it's solved.
      I update the excel template in the template directory by modifying the Cell styles "Normal" as per your suggestion. it's working. Updates in the working sheet will change time by time but updates in the excel tem

       

      plate (Book & Sheet) are fixed permanently. 

Resources