Excel Examples

Insert Character or Text to Cells

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 »

How to Get the Data Size of Each Worksheet in a Workbook

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 »

How to Replace Duplicates with Blank Cells in Excel

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 »

How to Filter Cells with Bold Font Formatting in Excel

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 »

How to Check If a Number is Integer in Excel

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 »

How to Ignore Blank Cells in a Formula in Excel

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 »

Excel: Always Match Destination Formatting while Pasting

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 »

Repeat Cell Value N times in Excel

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 »

How to Change the Color of ActiveX Command Button in Excel

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 »

Show Only Positive Values

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 »

How to Show Image on Mouseover in Cell

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 »

Insert The File Path and Filename into Header or Footer

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 »

How to Sum in Horizontal Range

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 »

How to Calculate Sum of a Column Ignore #N/A in Excel

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 »

How to Concatenate Cells and keeping Date Format in Excel

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 »

Sidebar