Learn Microsoft Excel Online Free
This post will guide you how to insert character or text in middle of cells in Excel. How do I add text string or character to each cell of a column or range with a formula in Excel. How to add text to the beginning of all selected cells in Excel. How to add character… read more »
This post will guide you on how to stop splitting text to columns when pasting data from text into Excel. We often copy texts from Text into Excel and split the texts into different columns or rows by some rules via Text to Columns function. And next time you copy a series of texts, Excel… read more »
This post will guide you how to find the first value greater than a specified value in a range of cells in Excel. How do I find the last value greater that a given value in a row with a formula in Excel. Assuming that you have a list of data in range B1:B6, in… read more »
If you’re working with large workbooks in Excel, you may find it useful to know the size of each worksheet within the workbook. This information can help you identify which worksheets are taking up the most space and optimize your file for better performance. This post will guide you how to check the size of… read more »
This post will guide you how to remove duplicates and replace with blank cells in Excel 2013/2016. How do I replace the duplicates with blank cells using a formula in Excel. 1. Replace Duplicates with Blank Cells Using Formula Assuming that you have a list of data in range B1:C4, and you want to remove… read more »
This post will guide you on how to filter cells with bold font formatting in Excel 2013/2016/2019/365 using different methods such as Find and Replace, VBA code. Filtering cells based on formatting can be very useful when you have a large dataset and want to quickly identify and extract specific data points. We will explore… read more »
This post will guide you on how to check if a number is an integer in Excel using different methods. Excel provides built-in functions such as the INT and MOD functions that you can use to determine if a number is an integer. Additionally, you can create a user-defined function using VBA code to check… read more »
If you frequently work with large sets of data in Excel, you may have encountered the issue of dealing with blank cells when performing calculations. The presence of blank cells in a formula can often cause errors or affect the accuracy of your results. To avoid this problem, it’s important to know how to ignore… read more »
This post will guide you how to retain the text format always match destination formatting while copy/paste content in Excel. Is there a way to set default to always match destination formatting when pasting into Excel. When you copy data from a word document or other external application, Excel will use the original formatting for… read more »
This post will guide you through two different methods to repeat cell values N times in Excel, including using the VLOOKUP function, and VBA code. 1. Repeat Cell Value N Times using VLOOKUP Function Assuming that you have a list of data that contain two column and one column is cell value that you want… read more »
This post will introduce you to three methods for calculating the average of a range of numbers in Microsoft Excel, excluding the smallest and largest values. The first and second method involves using the formula, while the third method utilizes VBA code. 1. Calculate the Average Excluding the Smallest and Highest Numbers Using Formula Calculating… read more »
This post will guide you how to change the color of ActiveX command button in Excel. How do I change the background color of a button with VBA Macro in Excel. How to assign a VBA Macro to change the color of ActiveX command button in Excel. 1. Changing the Color of ActiveX Command Button… read more »
This post will guide you on how to show only positive values in Excel. There are several ways to accomplish this, including formatting cells, using conditional formatting, and using VBA code. We will discuss each method in detail and provide step-by-step instructions on how to implement them. 1. Video: Show Only Positive Values In this… read more »
This post will explain various methods to exclude values from one column based on values in another column in Excel. Often, while working with large datasets, we need to remove certain values from a column based on criteria from another column. we will cover three different approaches to achieve this: using the VLOOKUP function, the… read more »
This post will guide you through the process of showing an image on mouseover in one cell in Excel 2013/2016/2019/365. This can be a helpful way to provide additional information or context for data in your spreadsheet. We will provide step-by-step instructions for adding a pop-up image to a cell when mouse hovers in your… read more »
This post will guide you how to add the file path and filename into a header or footer in Excel. How do I insert the file path and filename into the current worksheet header or footer in Excel. 1. Video: Insert The File Path and Filename into Header or Footer This video demonstrates how to… read more »
To add numbers together we need to apply SUM function. But if we want to add numbers based on some conditions, we can add criteria with the help of SUMIFS function, SUMIFS can filter data with multiple criteria effectively. In this article, we will introduce you the method of applying SUMIFS function about sum numbers… read more »
If you need to calculate the sum of a column in Excel while ignoring #NA errors, this post will guide you through three different methods to accomplish this task. Each method has its own advantages and limitations, so you can choose the one that works best for your specific situation. Additionally, if you prefer to… read more »
This post will guide you on how to combine text and date into the same cell in Excel while keeping the date format in Excel 2010/2013/2016 or Excel 365. We will show you how to concatenate text and date while preserving the date format, using both formula and VBA code methods. In some cases, you… read more »
This post will guide you on how to find and replace values greater than or less than a fixed value in Microsoft Excel using VBA code. In this post, we will walk you through the steps to create a VBA macro that will search for values that meet certain criteria and replace them with a… read more »
