Excel

Disable conversion of two numbers with dash as date in Excel

March 10, 2023 by Admin 3 Comments

Microsoft Excel has a feature that automatically coverts two numbers separated by dash in to a date formatted value. For example if you type 6-7 in a cell, Excel would reformat this in to a date value as 7-Jun. But if you do not want to reformat then you can use any of the below mentioned solutions to disable this feature.

Solution 1: Prefixing the values with apostrophe

The simplest solution is to add apostrophe before 6-7. This would display the typed value without reformatting it.

Solution 2: Change format to Text Format

Another alternate solution is to change the formatting of the cell to Text format. Select the cell (or columns), right click and pick Format Cells from the menu list.

In the Format Cells window, select Text Format under Number tab and click OK button to apply the changes.

Also See: How to add country code to phone numbers in Excel

How to Protect Formulas in Excel

February 22, 2023 by Admin Leave a Comment

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

First, select the cells that contain the formulas you want to protect. You can select a range of cells by clicking and dragging, or by holding down the Shift key and clicking the first and last cell in the range.

Step 2: Open the Format Cells dialog box

Next, right-click on the selected cells and choose “Format Cells” from the context menu. This will open the Format Cells dialog box.

Step 3: Select the Protection tab

In the Format Cells dialog box, click on the “Protection” tab. Here, you can choose to protect the cell’s contents or formatting. To protect the formulas, make sure the “Locked” checkbox is checked. And to hide the formulas, make sure the “Hidden” checkbox is checked.

Step 4: Protect the worksheet

Now that the cells with formulas are locked, you need to protect the entire worksheet. To do this, go to the “Review” tab and click on “Protect Sheet”. This will open the Protect Sheet dialog box.

In the Protect Sheet dialog box, you can choose which elements of the worksheet to protect. By default, all elements are selected, which means that users won’t be able to edit any cell on the worksheet. You can also choose to allow certain users to edit specific ranges of cells.

Step 5: Enter a password

In the Protect Sheet dialog box, you can also enter a password. This password will be required to unprotect the worksheet. Make sure to choose a password that’s easy for you to remember, but difficult for others to guess.

Step 6: Click OK

Finally, click OK to protect the worksheet. You should now see a message that the worksheet has been protected. Users will only be able to edit cells that are not locked or protected.

By following these steps, you can protect the formulas in your Excel worksheet and ensure that your data remains accurate and consistent.

In conclusion, protecting formulas in Excel is a simple but important step to safeguarding your data. By using the locking and protection features in Excel, you can prevent accidental changes to your formulas, and keep your data safe from unwanted edits.

How to Change the Default Font in Excel

February 18, 2023 by Admin Leave a Comment

To change the default font in Excel, follow these steps:

Open a new or existing Excel workbook.
Click on the ‘Excel’ -> ‘Preferences’ in case of Mac and ‘File’ tab -> ‘Options’ in case of Windows
In the ‘General’ tab, scroll down to ‘Default Font’ then Click on the drop-down menu next to ‘Use this font’ and select the font you want to use as the default.
Optionally, you can also change the font size and style.
Close and restart Excel for this change to be in effect..

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 for each of them individually.

How to Add Country Code to Phone Automatically in Excel

February 15, 2023 by Admin 1 Comment

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 automatically in Excel.

Method 1

Step 1: Determine the Country Code The first step is to determine the country code you want to add to the phone numbers. You can find this information easily by searching on the internet. For example, if you want to add the country code for the United Kingdom, it is “+44”.

Step 2: Create a new column next to the column that contains the phone numbers. This is where we will add the country code.

Step 3: Enter the Formula In the first cell of the new column, enter the following formula: =IF(LEFT(B1,1)=”+”,C2,”+1″&B2)

This formula checks whether the first character of the phone number is already a plus sign, which indicates that the country code is already included. If it is, the formula leaves the phone number as it is. If it isn’t, the formula adds the country code before the phone number.

Note that in the above screenshot the phone numbers are in column B starting from the second row (i.e., cell B2). Adjust the formula accordingly if your data is located elsewhere.

Step 4: Copy the Formula Now copy the formula to the entire column by clicking on the bottom right corner of the cell and dragging it down. This will apply the formula to all the cells in the column.

Step 5: Check the Results After copying the formula to all the cells, the new column should now contain the phone numbers with the country code added automatically. Check the results to ensure that the country code has been added correctly.

Method 2:

Step 1: Right click on the column where you want to display the phone number.

Step 2: Select Format Cells from the menu list.

Step 3: Under Category select Custom and enter +44 000-000-000 in Type field. Then Ok to save the changes.

Step 4: Now entering a phone number like “1234567890” will be automatically changed to “+44 1234-567-890”

That’s it! You have successfully added country codes to phone numbers automatically in Excel. These methods can save you a lot of time and reduce the chance of errors in your data.

How to Insert Pictures in Excel

February 11, 2023 by Admin Leave a Comment

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 how to insert pictures in Excel and provide tips for formatting and positioning them.

Step 1: Select the Cell The first step in inserting a picture in Excel is to select the cell where you want the picture to appear. This will ensure that the picture stays in place and doesn’t move as you make changes to the spreadsheet.

Step 2: Insert Picture Once you’ve selected the cell, go to the “Insert” tab and click “Picture.” You can then select the picture you want to insert from your computer or from a file on your network.

Step 3: Resize and Format Once you’ve inserted the picture, you can resize it to fit the cell or the entire spreadsheet. To do this, click and drag the edges of the picture until it’s the size you want. You can also use the “Format Picture” option to adjust the picture’s brightness, contrast, and other attributes like Fill & Line, Effects, Size and Properties

By following these steps, you’ll be able to easily insert pictures into your Excel spreadsheets and add a visual touch to your data. Whether you’re creating a presentation, a report, or simply organising your data, adding pictures in Excel is a useful skill to have.

Adding Subscripts and Superscripts in Excel

February 9, 2023 by Admin Leave a Comment

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 Excel to enhance the readability and visual appeal of your data.

How to Add Subscripts in Excel

Select the cells where you want to add the subscripts.

Right-click on the selected cells and choose “Format Cells.”

Go to the “Font” tab and find the “Subscript” or “Superscript” option.

Check the “Subscript” or “Superscript” box to apply the format to the selected cells.

Enter the text or numbers you want to appear as subscripts in the selected cells.

With the steps outlined above, you can easily add subscripts and superscripts to your data in a matter of minutes.