How to fix Microsoft Excel font style and font size mismatch?

Question

I need to create an economic analysis output information pool in an Excel spreadsheet I prepared in German Language. When creating the salary table of various occupational groups in Germany, I place the results of the calculations on the stundenlohnrechner website in rows and columns. However when I copy the output values ​​of the site while I want to prepare it in Times New Roman style and 13 points, I am forced to 19.5 point size and Arial font, which is the style used by the site. I can easily change the font size on Excel, but when I want to change the font size at the same time, the entire table I prepared shifts. How can I make an automatic adjustment to automatically copy a writing according to the default values ​​that I have prepared beforehand when copying something from a website? Since I usually work on financial statements, I usually need to copy and insert numbers into tables. And I have this problem a lot, especially with comma numbers that indicate price or salary.

I am sure there is a very easy and automatic solution to this, I am waiting for your solution suggestions: The licensed Excel program I use is in German and I usually have no problem quoting from English language sites, but this problem often occurs when quoting from German websites. I wonder if making English the default in the language settings will have any effect on solving this problem?

Answer 1

Hi,

How did you import the web to Excel? Did you use Power Query or other methods?

If you copy and paste directly, you can keep source formatting.

Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.