Category: Excel
-
How to Change the Decimal Separator in Excel
Why Change the Decimal Separator? Different regions around the world use different characters as decimal and thousands separators. For example, in the United States, a period (.) is commonly used as a decimal separator, while a comma (,) is used to separate thousands. In many European countries, the opposite is true—a comma is used as…
-
How to Protect Formulas in Excel
Excel formulas are a powerful tool for automating calculations, but they can also be fragile if accidentally deleted or overwritten. Protecting your formulas is a critical step to ensuring the integrity of your data. In this post, we’ll walk through how to protect formulas in Excel. Step 1: Select the cells you want to protect…
-
How to Change the Default Font in Excel
To change the default font in Excel, follow these steps: From now on, every new workbook you create in Excel will use the font you selected as the default. Keep in mind that changing the default font will not affect any existing workbooks you have already created – you will need to change the font…
-
How to Add Country Code to Phone Automatically in Excel
Do you need to add country codes to a long list of phone numbers in Excel? Doing this manually can be time-consuming and prone to error. However, there is a way to automate the process using a formula in Excel. In this tutorial, we’ll show you two methods for adding country codes to phone numbers…
-
How to Insert Pictures in Excel
Excel is a powerful tool for organising and analysing data, but sometimes you need to add a visual touch to your spreadsheets. Whether it’s for a presentation, a report, or simply to make your data easier to understand, inserting pictures in Excel is a useful skill to have. In this blog post, we’ll show you…
-
Adding Subscripts and Superscripts in Excel
Subscripts and superscripts are useful formatting tools in Excel when it comes to writing formulas or adding special characters to your data. Subscripts appear lower and smaller than the surrounding text, while superscripts appear higher and smaller than the surrounding text. In this tutorial, we will show you how to add subscripts and superscripts in…