Bulk Find and Replace in Excel
In Excel, the built-in Find and Replace feature works great when you need to find and replace a single value. But if you’re dealing with
SPREADSHEET PLANET
Time Saving Excel Tips & Tutorials
I am Steve Scott and I regularly write about easy to follow how-to tutorials about Excel spreadsheets. I started this website as a side project to document some of the cool things I was learning in MS Excel, and now I am so happy that it reaches thousands on Excel learners every day.
Remember, Excel is not just a software – it’s a skill that can significantly boost your productivity and career. So dive in, explore the tutorials, and happy Excelling!
POPULAR EXCEL ARTICLES
LATEST EXCEL ARTICLES
Get a List of All Sheet Names in Excel
You may want to list all sheet names in your Excel workbook, for instance, when creating a Table of Contents (TOC) for easy navigation across
How to Open Multiple Instances in Excel
In Excel 2013 and later, each workbook you open is displayed in its own window. However, all the open workbooks run within a single Excel
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
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
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