Generate All Possible Combinations from Two Lists
In Excel, you may sometimes want to generate all possible combinations from two lists, for instance, to display all product variations. I will show you how to accomplish this in …
Steve Scott
Convert Fraction to Decimal in Excel
In Excel, working with decimals is often easier than fractions. That’s why you might want to convert fractions to decimals—it just makes things simpler. I will show you how to …
Make Pivot Table from Multiple Sheets
You want to create a Pivot Table from data spread across multiple sheets in a workbook. How do you do it? In this tutorial, I will show you three ways …
Reorder Rows in Pivot Table in Excel
When you create a Pivot Table, by default, Excel orders the rows based on the row labels’ data type. This means that: If the default row order in a Pivot …
Count Distinct Values in Excel Pivot Table
When you create a standard Pivot Table from a dataset containing duplicate values, the count summary will, by default, include all values, including duplicates. For instance, in the dataset shown …
Count Colored Cells in Excel
You may get a dataset with colored cells done manually or using conditional formatting to highlight specific data, such as completed tasks, pending approvals, or key milestones. To analyze this …
Change a Pivot Table to Tabular Form
You can switch a Pivot Table layout from the default Compact Form to a Tabular Form to view data in a traditional flat table layout. The Tabular Form layout makes …
How to Lock Pivot Table Column Width
By default, a Pivot Table automatically adjusts column widths to fit new or updated content when refreshed or filtered. This default setting can disorganize your worksheet’s layout and be frustrating …
How to Undo Delete Sheet in Excel
You delete a sheet in Excel, and then, oops! You realize you shouldn’t have deleted it. How do you recover it? Excel does not have an ‘Undo (CTRL + Z)’ …
Convert Latitude Longitude to Address in Excel
You convert latitude and longitude coordinates into an address because it is easier for humans to understand an address than coordinates. For instance, ‘123 Main Street, New York’ is far …
How to Write Vertically in Excel
Sometimes, you may need to write or type vertically in Excel to fit data within narrow columns, organize data, or enhance the visual layout. For instance, in the example duty …
How to Add Months to a Date in Excel
When working with dates in Excel, you may need to add months to a particular date to calculate a future date. For example, as a project manager, you might need …