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 multiple sheets. I will show ... Read more| Spreadsheet Planet
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 instance by default. This means ... Read more| Spreadsheet Planet
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 ... Read more| Spreadsheet Planet
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 ... Read more| Spreadsheet Planet
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 ... Read more| Spreadsheet Planet
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 ... Read more| Spreadsheet Planet
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 ... Read more| Spreadsheet Planet
Learn why dates in Excel show as hashtags and how to fix it. Column width, negative numbers, date values outside Excel's range. are common causes| Spreadsheet Planet
Learn how to quickly get the first day of the month in Excel using simple formulas (DAY or EOMONTH) or a simple VBA macro code.| Spreadsheet Planet
Learn how to convert serial numbers to date in Excel using TEXT function, number formatting, and VBA macro codes.| Spreadsheet Planet
Learn how to convert a month number to its corresponding name in Excel using the TEXT and CHOOSE functions. Also, discover how to extract the month name from a given date using different methods.| Spreadsheet Planet
Learn how to add a specific number of days to a date in Excel using simple formulas and the DATE() function. Easily calculate future dates for delivery, payroll, and more.| Spreadsheet Planet
Learn how to easily remove table formatting in Excel using various methods such as using the ribbon, clearing all formatting, and VBA script.| Spreadsheet Planet
Learn how to easily remove negative signs in Excel with some practical methods (such as Flash Fill, formulas, and Find and Replace)| Spreadsheet Planet
Learn four ways for formatting numbers in millions in Excel, including custom number formatting, using the TEXT function, the ROUNDUP function, and changing display units on a chart.| Spreadsheet Planet
Learn about the five basic data types in Excel - Number, Date and Time, Text, Logical, and Error. Understand how to use and manipulate each data type effectively for creating useful worksheets.| Spreadsheet Planet
Learn how to change the font color of cells in Excel based on their values, whether it's positive/negative numbers, specific values, or text, using Conditional Formatting and Custom Number Formatting.| Spreadsheet Planet
Learn how to apply the Accounting Number Format in Excel using three different methods. Also understand the differences from the Currency format| Spreadsheet Planet
AutoFill is a handy feature in Microsoft Excel that allows you to fill in cells with data quickly and easily.| Spreadsheet Planet
You sometimes need to represent text data as bullet points in Excel. For example, you might need to display bulletin boards, to-do lists, etc.| Spreadsheet Planet
Learn how to count filtered rows in Excel using simple methods like the SUBTOTAL and AGGREGATE functions. Save time and avoid headaches with these nifty tricks!| Spreadsheet Planet
Is your Excel file running slow? Learn why Excel is slow and how to fix it with these 11 tips to speed up your slow Excel files.| Spreadsheet Planet
Learn how to count cells with text in Excel using simple formulas and wildcard characters. This tutorial covers various scenarios, including excluding blank cells and apostrophes.| Spreadsheet Planet
Learn how to count non-blank cells in Excel using various formulas such as COUNTA, COUNT, SUBTOTAL, COUNTIF, SUMPRODUCT, and more.| Spreadsheet Planet
Learn how to easily count the number of cells with a value between two numbers in Excel using functions like COUNTIFS, SUM, IF, and SUMPRODUCT.| Spreadsheet Planet
Learn how to add leading zeros in Excel using various methods such as apostrophe, custom number formatting, and functions. Find out how to retain leading zeros and apply these methods to multiple cells.| Spreadsheet Planet
Learn how to calculate percentage difference in Excel using simple formulas. Understand difference between percentage difference & change| Spreadsheet Planet
Learn three ways to calculate cumulative percentage in Excel, including manual computation, using a formula, and using a pivot table.| Spreadsheet Planet
Learn how to calculate hours between two times in Excel using simple multiplication, the TEXT function, and the HOUR function.| Spreadsheet Planet
Learn how to remove leading spaces in Excel using five different techniques, including the TRIM function, Flash Fill, and Find and Replace.| Spreadsheet Planet
Fixing the #NUM! error in Excel is frustrating, but this tutorial provides detailed steps on identifying and resolving the causes of the error.| Spreadsheet Planet
Learn how to fix the #NAME error in Excel formulas caused by misspelled function names, incorrect cell references, and other common mistakes.| Spreadsheet Planet
Compare Microsoft Excel and Google Sheets to find the best spreadsheet tool for your needs. Learn about cost, functions, and functionalities in this head-to-head comparison.| Spreadsheet Planet
Learn how to fix the 'Formulas not copying down in Excel' issue with this comprehensive tutorial. Explore common reasons and solutions for this frustrating issue.| Spreadsheet Planet
Learn how to find out the version of Excel you're using, whether it's 2013, 2016, 2019, or Microsoft 365, using menus or VBA script.| Spreadsheet Planet
Learn why Excel shortcuts may not be working and how to fix them. Possible reasons include media keys, language bars, keyboard layout, and macro conflicts.| Spreadsheet Planet
Learn 10 ways to fix Excel not responding errors, including repairing files, disabling add-ins, and launching in safe mode. Get your Excel back on track!| Spreadsheet Planet
Learn how to subtract multiple cell values from one cell in Excel using formulas, Paste Special feature, and VBScript. Find out the difference between absolute and relative cell references and choose the best method for your needs.| Spreadsheet Planet
Learn how to select visible cells only in Excel using keyboard shortcuts, Go To Special dialog box, and Quick Access Toolbar. Copy and paste only the visible cells to exclude hidden ones.| Spreadsheet Planet
Learn 5 simple ways to select non-adjacent cells in Excel, including using keyboard and mouse maneuvers, the Name Box, Find and Replace, and the Go To feature.| Spreadsheet Planet
Learn how to select every other row in Excel using manual selection, helper column & filter, and VBA methods.| Spreadsheet Planet
Learn how to quickly select every other cell in Excel using three ingenious tricks (using Go To special, Filter, and a VBA macro code)| Spreadsheet Planet
Learn how to highlight every other row in Excel using Conditional Formatting, Banded Rows Table Styles, and VBA. Make your data more readable and easier on the eyes with these simple techniques.| Spreadsheet Planet
Learn how to select multiple rows in Excel, whether they are contiguous or non-contiguous, using simple and quick methods.| Spreadsheet Planet
Learn 5 ways to remove blank rows in Excel, including VBA scripting, with this comprehensive tutorial. Keep your dataset clean and error-free.| Spreadsheet Planet
Learn how to quickly fill blank cells with a dash (-) in Excel using Find and Replace, 'Go To Special' technique, and VBA code.| Spreadsheet Planet
Learn how to quickly fill all the blank cells with 0 in Excel using Find and Replace, Go to Special, and VBA code.| Spreadsheet Planet
Learn how to master Visual Basic for Applications (VBA) in Excel with this easy guide. Understand how to automate tasks and write macros in Excel.| Spreadsheet Planet
Learn how to add the Developer tab in Excel and access advanced features like VBA programming and macros. Follow our tutorial for step-by-step instructions.| Spreadsheet Planet
Learn how to Paste without Formatting in Excel using keyboard shortcuts for Windows and Mac. Also includes a less-known Control trick| Spreadsheet Planet
Learn how to filter data in Excel based on cell color using different methods such as the filter option, right-click menu, custom sort, and VBA script.| Spreadsheet Planet
Learn how to clear filters in Excel with simple keyboard shortcuts or using the ribbon option + learn how to identify if filters have been applied| Spreadsheet Planet
In this tutorial, I will show you the step-by-step process to highlight a cell if the a value exists in another column in the worksheet in Excel.| Spreadsheet Planet
Sometimes when you receive a dataset with duplicates you may need to group the duplicates so you can easily identify them and decide to remove or consolidate| Spreadsheet Planet
Learn three easy ways to get unique values from a column in Excel: Remove Duplicates tool, Advanced Filter, and UNIQUE function.| Spreadsheet Planet
In this tutorial, I will show you two ways to find merged cells in Excel (using Find and Replace and VBA). Once found, you can unmerge these or highlight these| Spreadsheet Planet
Learn three easy ways to fill blank cells with the value above in Excel (using 'Go To Special' with a formula, 'Find and Replace' with formula, or VBA)| Spreadsheet Planet
Filling colors in cells in Excel could be quite useful.| Spreadsheet Planet
Learn how to use conditional formatting with OR criteria in Excel to highlight data that meets at least one condition.| Spreadsheet Planet
Learn how to quickly unhide all rows in Excel using VBA. This tutorial provides VBA code to unhide rows in a specific range or all worksheets| Spreadsheet Planet
Learn three simple ways to remove macros from an Excel workbook (save in XLSX format, using Macro Dialog Box, and Visual Basic Editor)| Spreadsheet Planet
Learn how to filter data dynamically as you type in Excel using the FILTER function in Office 365 ((No VBA needed)) or using a simple VBA code| Spreadsheet Planet
Learn how to easily delete sheets in Excel using VBA with just a few lines of code. Save time and effort with this simple automation technique.| Spreadsheet Planet
Learn how to quickly delete hidden rows and columns in Excel using the Inspect Document feature or VBA code (without manually doing it)| Spreadsheet Planet
Learn how to change cell color based on the value of another cell in Excel using a formula in Conditional Formatting.| Spreadsheet Planet
Learn how to UnSort your dataset in Excel and revert back to the original data using a temporary column or creating a backup copy.| Spreadsheet Planet
Learn how to quickly unmerge all cells in Excel using the Merge and Center button, Find and Replace, VBA script, and how to copy original values to unmerged cells.| Spreadsheet Planet
Learn five super easy methods to swap columns in Excel, including drag and drop, cut and paste, sorting, SORTBY function, and copy, paste, and delete.| Spreadsheet Planet
Have you ever wondered if there's an easy way to swap cells in Excel?| Spreadsheet Planet
Learn how to easily sort data by date in Excel using simple steps. From sorting single columns to multiple columns, and troubleshooting common issues, this tutorial has got you covered.| Spreadsheet Planet
Learn 4 different methods to enter sequential numbers in Excel, including using the Fill Handle, ROW function, SEQUENCE function, and converting the dataset into a table.| Spreadsheet Planet
Learn how to quickly rearrange rows in Excel using different methods like shift key and mouse, cut copy method, insert row and cut/copy method, and sorting.| Spreadsheet Planet
Learn how to move rows to another sheet in Excel based on a specific cell value using filters trick and simple VBA macro codes.| Spreadsheet Planet
Learn three easy ways to quickly convert positive numbers to negative in Excel - using Paste Special, formulas, and VBA| Spreadsheet Planet
There is often a need to transpose data in Excel, where you may want to convert rows to columns and columns to rows.| Spreadsheet Planet
Inserting a column is a common task for anyone working with data in Excel. And there are multiple ways you can add a column in Excel.| Spreadsheet Planet
Absolute cell reference in Excel is a way to refer to a specific cell or a range of cells that doesn't change even when the formula is copied or moved to| Spreadsheet Planet
Learn multiple ways to convert columns into rows in Excel, including using the transpose feature, paste special, keyboard shortcuts, and the TRANSPOSE function.| Spreadsheet Planet
XLOOKUP and INDEX MATCH are Excel functions for performing lookups.| Spreadsheet Planet
Learn to master VLOOKUP Approximate Match in Excel: Understand its nuances, uses, and how it compares to Exact Match (practical examples)| Spreadsheet Planet
Learn everything about the Formula Bar in Excel - where to find it, how to show/hide, shortcuts, and how it makes working with large formulas easier!| Spreadsheet Planet
Learn how to round up to the nearest whole number (even, odd, or multiple of 3 and 5) in Excel using simple formulas.| Spreadsheet Planet
Learn how to round numbers to the nearest 100 in Excel using functions like ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, & MROUND| Spreadsheet Planet
Learn how to effectively get the cell address of a specific value in Excel using built-in functions like ADDRESS and CELL. (absolute or relative address)| Spreadsheet Planet
When working with a dataset in Excel, you may need to find the row number of a specific value to retrieve related information.| Spreadsheet Planet
Learn how to find the last occurrence of a value in a column in Excel using XLOOKUP, INDEX, Find and Replace, and a VBA (User Defined Function)| Spreadsheet Planet
Learn how to find the last Monday of the month in Excel using a single formula, involving the EOMONTH and WEEKDAY functions.| Spreadsheet Planet
Learn how to use the COUNTIF function in Excel for partial matching, including wildcard characters, with helpful examples and explanations.| Spreadsheet Planet
Learn different methods to check if a value is in a list in Excel, including using functions like COUNTIF, OR, and MATCH. Find out how to validate data in large datasets.| Spreadsheet Planet
Learn how to sum only positive numbers in Excel using the SUMIF function or VBA. This tutorial provides step-by-step instructions for both methods.| Spreadsheet Planet
Learn how to remove conditional formatting in Excel. Clear rules from selected cells, entire sheet, tables, and more.| Spreadsheet Planet
The format of the cells plays a huge role in Excel.| Spreadsheet Planet
People who work with multiple open Excel workbooks find it irritating to close specific files by clicking on the close icon at the top-right part of the Excel| Spreadsheet Planet
Learn 5 methods to count unique values in Excel using formulas. Find out how to exclude empty cells and improve performance for large datasets.| Spreadsheet Planet
Learn how to select rows with specific text in Excel using a simple VBA code or a simple Data Filters trick.| Spreadsheet Planet
Learn how to hide rows in Excel based on specific cell values using filters and VBA. This tutorial provides step-by-step instructions & code examples| Spreadsheet Planet
Learn how to format phone numbers in Excel for better readability and auto-formatting. Create custom number formats for international and local codes.| Spreadsheet Planet
Learn how to remove formulas but keep the data in Excel using a simple shortcut, the paste special technique or a simple VBA code.| Spreadsheet Planet
Learn how to copy formatting in Excel using Format Painter, Paste Special, Fill Handle, and more. Easily apply formatting to single or multiple cells with these simple methods.| Spreadsheet Planet
Learn how to remove middle names from full names in Excel using Flash Fill, Find and Replace, Text to Columns, TEXTSPLIT Function, and more.| Spreadsheet Planet