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

Sometimes, in Excel, you want to calculate the average of absolute values. If we consider the values as positive, even if they are negative, then they are called the absolute values. The absolute values are always positive. Basically, absolute values are used in calculating distances or inequalities. If we want to calculate the average distance travelled by a delivery person in a day, we can use this process. This tutorial will help you understand how we calculate averages for absolute values in Excel. Average Absolute Values in Excel with Helper Column Here, we will first use the ABS formula and ... Read More

You could have applied the average function to tables in Excel, but have you ever tried to use the average in filtered cells? When we apply the direct formula to the filtered cells, the result is an error. There is a special method for finding the average for filtered cells. This tutorial will help you understand how we can average filtered cells in Excel. We can complete this process just by using the simple formulas supported by Excel. Average Filtered Cells/List in Excel Here we will first create the table, then insert the slicer and use the SUBTOTAL formula to ... Read More