How to change the decimal separator in Excel

Microsoft Excel 2013 and 2010 by default uses the system defined decimal separator. In Windows 8 and Windows 7 this option is defined under the Regional and Language Settings available under Control Panel. You can follow below steps to change the decimal separator in Excel. Step 1: Right click on the bottom end corner of […]

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 […]