Excel Examples

Sum the Absolute Values in Excel

This post will guide you how to sum the absolute values in a range of cells in Excel. How do I sum the absolute values with a formula in Excel 2013/2016. Sum the Absolute Values Assuming that you have a list of data in range B1:B6 that contain negative numbers and positive numbers, and you… read more »

Find and Replace Multiple Values in Excel

This post will guide you how to find and replace multiple values at once with VBA macro in Excel. How do I make multiple find and replace in Excel. Find And Replace Multiple Values in Excel Assuming that you have a list of data in range B1:B6, and you want to find multiple values and… read more »

Find Closest Value or Nearest Value in a Range in Excel

This post will guide you how to find the closest value or nearest value in a range of cells or in a column in Excel. How do I find the closest match in a range to a given lookup value in Excel. How to find the closest larger and closest smaller values from a range… read more »

Change Uppercase to Title Case or Sentence Case in Excel

This post will guide you how to change uppercase letters to sentence case with a formula in Excel. How do I change uppercase to title case in Excel. How to change Uppercase to title case or sentence case with VBA macro in Excel. Change Uppercase to Title Case If you want to change uppercase letters… read more »

Copy and Paste Multiple Selections or Ranges in Excel

This post will guide you how to copy and paste the multiple selections or ranges in Excel. How do I select and copy multiple ranges with VBA macro in Excel. How to copy multiple non adjacent cells in Excel. Copy and Paste Multiple Selections If you want to copy and paste multiple selections in your… read more »

Create a Searchable Drop Down List in Excel

This post will guide you how to create a searchable drop down list in Excel. How do I create an excel drop down list with search suggestions in Excel. How to search data validation drop down list in Excel. Create a Searchable Drop Down List If you want to create a searchable drop down list… read more »

Insert Unique Sequential Numbers

This post will guide you how to generate unique sequential numbers in Excel. How do I insert unique sequence numbers to your worksheet in Excel. Insert Unique Sequential Numbers Assuming that you want to insert unique sequential numbers, such as: 1,2,3….in Excel. You just need to do the following steps: #1 select one cell, and… read more »

Find Missing Numbers in a Sequence in Excel

This post will guide you how to find missing numbers in a sequence with a formula in Excel. How do I identify missing numbers in a consecutive series in Excel. How to find missing serial number in Excel 2013/2016. Find Missing Numbers in a Sequence in Excel Assuming that you have a serial number list… read more »

Fit Worksheet on One Page in Excel

This post will guide you how to shrink a worksheet to fit on one page in excel. How do I shrink the printout so that it fits on one page in Excel. How to scaling your worksheet for printing so that your data can fit to one page in Excel 2013/2016. Fit to One Page… read more »

Extract Time or Hour Only from a Date and Time in Excel

This post will guide you how to extract time from a data and time value with a formula in Excel. How do I extract time from a date-time number in Excel 2013/2016. How to extract hour only from the date time format in Excel. Extract Time from Date and Time If you want to extract… read more »

Sidebar