Occasionally we might need to separate the numbers from the text or obtain simply the numbers out of any input that contains both text and numbers. Excel has a variety of shortcuts that eliminate the need to manually do this task, making it possible to isolate integers from any dataset. In this tutorial, I will demonstrate a technique for separating nmbers in Excel by using formulas in a variety of circumstances. Break or Split Numbers into Individual Digits using Formulas in Excel In the following part, a formula will be presented that may be used in Excel to split chosen ... Read More

In situations when there are unusually large or small series or points in the source data, the chart's representation of the small series or points will not be exact enough. In situations like these, some users may desire to break the axis in order to achieve precision in both the tiny series and the large series at the same time. You will learn two different techniques to break chart axis in Excel by reading this post. Break Chart Axis with a Secondary axis in Chart in Excel Take, for instance, assuming that you have the data in two different ranges, ... Read More

In Excel, the lines that make it up a cell’s border are referred to as boxes by maintain borders, we are able to frame any data and give it a defined boundary in an appropriate manner. You can highlight specific values by outlining summarized values or separating data into ranges of cells, additionally, you can place borders around individual cells. Adding borders is one of the greatest and easiest ways to make a spreadsheet seem attractive, and this is especially true if the spreadsheet is going to be printed. However, if you are consistent including new data in your spreadsheet, ... Read More

In Excel, the lines that make it up a cell's border are referred to as boxes. By maintaining borders, we are able to frame any data and give it a defined boundary in an appropriate manner. You can highlight specific values by outlining summarized values or separating data into ranges of cells; additionally, you can place borders around individual cells. We might be familiar with the concept of adding colours for cells depending on the values of those cells; but, what about creating borders in Excel based on the values of the cells? Conditional formatting in Excel is discussed here, namely ... Read More

The default setting for the text label of checkboxes is to use a normal font type. In this tutorial, we will see how you can bold the text that is inside the checkboxes that are located in your worksheet. Bold text in Checkbox in Excel You can use the following steps to change the text label of checkboxes so that they use a bold font style. Let’s understand step by step with an example. Step 1 Adding a checkbox in Excel can be done in the following steps. Navigate to the Developer Tab and select Form controls and click ActiveX ... Read More

It's common practice to highlight individual cells in Excel, but sometimes you may want to highlight specific characters within a text string within a single cell, as illustrated.  This post will show you how to bold specific portions of a string of text within a cell. You can make a partial text string bold in a cell by following the instructions below. Let’s understand step by step with an example. Step 1 In the first step, let's assume we have a sample data as shown in the below screenshot. Step 2 You can edit the cell you want to ... Read More

When you are calculating some formulas in Excel, the result may be incorrect sometimes due of the rounding, and you may be wondering how to avoid making rounding errors while calculating in Excel. Avoid Rounding Errors while Calculating in Excel Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a product, sales and profit list for sample data as shown in the below screenshot for the same. Step 2 In the next step, we are trying to calculate the profit ratio using the below formula. Please checkout this screenshot ... Read More

Excel will display a notice known as a #REF error (the "ref" stands for reference) if a formula makes reference to a cell that does not now exist. This is typically the result of removing cells that a calculation is referring to. A competent financial analyst will be familiar with locating and correcting #REF problems in Excel, which are discussed in greater detail below. Avoid #ref Error while Deleting the Rows in Excel When you refer a cell to another cell, the cell that you are referring to will display the #REF error if the row that the cell is ... Read More

When we open a new excel sheet, we can see that the sheet will start from the cell A1, but when we open an existing worksheet, we can see that the sheet will start from where we last saved it. When we send the sheet to other people, they will be able to know where you last edited, but they will not be able to know if it starts in cell A1. This tutorial will help you understand how we can always open a workbook at cell A1. Here, we will have two parts: first, the code will work for ... Read More

Let us assume we have an Active X command on an Excel sheet at one place, and the data in the Excel sheet is in large volumes. If you want to use the active x command, we need to search for it every time. This problem can be solved by making the button floating. This article will help you understand how we can make the button always float in Excel. Floating a Command Button on a Worksheet Here we will first insert a button and then assign a macro to the button to make it always floating. Let us see a ... Read More