This page has all the articles published on Spreadsheet Planet
All Tips and Tutorials
- Generate All Possible Combinations from Two Lists
- Convert Fraction to Decimal in Excel
- Make Pivot Table from Multiple Sheets
- Reorder Rows in Pivot Table in Excel
- Count Distinct Values in Excel Pivot Table
- Count Colored Cells in Excel
- Change a Pivot Table to Tabular Form
- How to Lock Pivot Table Column Width
- How to Undo Delete Sheet in Excel
- Convert Latitude Longitude to Address in Excel
- How to Write Vertically in Excel
- How to Add Months to a Date in Excel
- How to Filter Strikethrough in Excel
- How to Group Duplicates in Excel
- Delete Multiple Sheets in Excel
- How to Return to Normal View in Excel
- Point and Click Method in Excel
- XLOOKUP Vs INDEX MATCH in Excel
- Find the Row Number of Matching Value in Excel
- Calculate Log Base 2 in Excel
- Calculate the Population Mean in Excel
- How to Create Dynamic Chart Titles in Excel
- Unblock Macros in Excel Files Downloaded From the Web
- How to Create Sankey Diagram in Excel
- How to Remove Numbers From Text in Excel
- Calculate Cube Root in Excel
- How to Left Align a Chart in Excel
- How to Interpolate in Excel
- How to Multiply Percentages in Excel
- Calculate Coefficient of Determination in Excel
- Calculate MEDIAN IF in Excel
- Excel Opens Blank Gray Screen – How to Fix!
- How to Make Cells Bigger in Excel
- How to Calculate Class Width in Excel
- 10 Best Fonts for Microsoft Excel
- How to Insert Word Document into Excel
- Excel Scroll Bar Too Long (How to Reset it)
- Unlock VBA Project Password in Excel
- Show Thousands as K in Excel
- How to Remove Page Numbers in Excel
- Remove Compatibility Mode in Excel
- How to Remove Groupings in Excel?
- How to Extract Part of Text in a Cell in Excel
- Merge Cells Without Losing Data in Excel
- #DIV/0! Error in Excel – How to Fix It?
- How to Transfer Excel Data to Access
- How to Reference a Cell on Another Sheet in Excel
- How to Make Scatter Plot in Excel
- How to Set Print Area in Excel (Easy Steps)
- Unprotect Excel Sheet Without Password
- Calculate Correlation Coefficient in Excel
- How to Make Excel Columns the Same Width
- Convert Time to Decimal in Excel
- How to Convert GMT to EST in Excel
- Excel vs. Power BI – What’s the Difference?
- Change Cell Color Based on Text Input in Excel
- How to Download One Sheet From Excel?
- Excel vs Access – Ultimate Comparison Guide
- Database vs Spreadsheet
- Using VLOOKUP Approximate Match in Excel (Examples)
- Remove Negative Sign in Excel
- How to Copy a Pivot Table in Excel?
- SEARCH vs FIND Function in Excel
- How to Transpose Multiple Rows into One Column in Excel
- How To Make Excel Spreadsheet Bigger When Printing
- Remove the Last 4 Characters in Excel
- Data Source Reference is Not Valid Error in Excel – Fix!
- Copy-Paste is Not Working in Excel – How to Fix?
- How to Resize Charts in Excel
- Excel Autofit Row Height Not Working – How to Fix
- How to Open BAK File in Excel?
- How to Swap Cells in Excel (3 Easy Ways)
- Useful Excel VBA Macro Codes Examples
- What is an XLK File?
- Split Text to Rows in Excel
- Excel Hyperlink Cannot Open the Specified File – Fix!
- Alt + Enter Not Working in Excel
- VBA Macro Codes to Filter Data In Excel
- How to Create Custom Lists in Excel?
- #REF! Error in Excel
- How to Write Scientific Notation in Excel?
- Extract Last Word in Excel
- Convert Number to Percentage in Excel
- How to Find the Largest Value in Excel
- How to Ungroup Sparklines in Excel
- Standard Deviation in Pivot Tables in Excel
- How to Separate Excel Tabs Into Separate Files
- Find the Position of a Character in a String in Excel
- Can’t Push Objects Off the Sheet in Excel – How to Fix!
- Find Last Occurrence of a Value in a Column in Excel
- How to Lock a Pivot Table in Excel
- Count Days from a Date to Today in Excel (Formula)
- How to Convert Date to Quarter in Excel
- Convert Latitude Longitude to Decimal Degrees in Excel
- Change Count to Sum in Excel Pivot Table
- Check If Value is in List in Excel
- How to Create QR Codes in Excel?
- How to Calculate Ratio in Excel?
- Change Cell Color Based on Value of Another Cell in Excel
- How to Calculate Elapsed Time in Excel
- How to Connect Slicer to Multiple Pivot Tables
- How to Create Bubble Chart in Excel
- How to Change Data Source in Pivot Table
- Separate Comma Separated Values in Excel
- Get Text to Fit in Cell in Excel
- How to Calculate Standard Deviation in Excel?
- How to Find the Column Number in Excel
- How to Overlay Graphs in Excel
- Extract ZIP Code from Address in Excel
- Convert Number of Days to Weeks in Excel
- XLTX vs. XLSX – Difference and Similarities
- Round to the Nearest Tenth in Excel
- XLSB vs. XLSX File Formats
- CSV vs. XLSX Files – What’s the Difference?
- How to Turn OFF Flash Fill in Excel
- Copy Conditional Formatting in Excel
- How to Replace Zero with Dash in Excel?
- Convert Days to Months in Excel
- Smooth Scrolling in Excel
- To Do this All Merged Cells Need to be the Same Size – Fix!
- Microsoft Excel is Waiting for Another Application to Complete an OLE Action – Fix!
- How to Calculate Growth Rate in Excel
- How to Clear Pivot Table Cache?
- XLS vs. XLSX Files – What’s the Difference?
- How to Remove Leading Spaces in Excel?
- How to Extract First Name in Excel
- How to Add Comma Between Names in Excel
- How To Highlight Weekends In Excel?
- How to Remove Strikethrough in Excel?
- How to Group by Quarters in Excel Pivot Table?
- Cannot Group That Selection Error in Pivot Tables
- Format Numbers to Show in Millions in Excel
- How to Convert Text to Sentence Case in Excel?
- Highlight Cells with Formulas in Excel
- Convert YYYYMMDD to MM/DD/YYYY in Excel
- #VALUE! Error in Excel – How to Fix!
- How to Calculate Covariance in Excel?
- #NAME? Error in Excel – How to Fix!
- How to Round Numbers in Excel Without Formula?
- Get File Names from a Folder into Excel (Copy Files Names to Excel)
- How to Generate Random Letters in Excel?
- How to Open VCF File in Excel?
- Formulas Not Copying Down in Excel – How to Fix!
- Excel Crashes When Opening File – Reasons + Fix!
- How to Filter Cells with Notes in Excel?
- How to Enable Manual Calculation in Excel?
- How to Delete Multiple Rows in Excel?
- Can’t Insert a Row in Excel – How to Fix!
- Data Types in Excel
- How to Get Sheet Names in Excel?
- How to Add Leading Zeros in Excel?
- How to Remove Add-Ins from Excel?
- How to Generate Random Names in Excel
- Excel Fill Series Not Working
- How to Select Multiple Items from a Drop Down in Excel?
- How to Swap Columns in Excel?
- How to Count Filtered Rows in Excel?
- Calculate Days Left in the Year (Formula)
- How to Select Every Other Row (Alternate Row) in Excel?
- How to Get Total Days in Month in Excel?
- How to Add Axis Titles in Excel?
- What Does F9 Do in Excel?
- How to COUNTIF Partial Match in Excel?
- How to Rotate Text in Excel?
- What Does Control + R Do in Excel?
- How to Calculate Variance in Excel?
- Not Enough Memory to Complete This Action in Excel – How to Fix?
- How to Get Rid of Green Triangles in Excel?
- How to Open an MPP file in Excel?
- How to Convert Text to Date in Excel?
- How to Count Between Two Numbers in Excel?
- Add Alt Text to an Object in Excel (Images / Charts / Shapes)
- How to Turn Off Error Sound in Excel?
- How to Calculate Nth Root in Excel?
- How to Calculate Mean Squared Error (MSE) in Excel?
- Opposite of Concatenate in Excel (Reverse Concatenate)
- How to Turn Off Autosave in Excel?
- How to Turn Off AutoFill in Excel?
- Convert KG to lbs (Pound) in Excel
- Count Cells that are Not Blank in Excel (Formulas)
- How to Apply Long Date Format in Excel?
- Count Cells Less than a Value in Excel (COUNTIF Less)
- Calculate the Coefficient of Variation in Excel
- How to Sum a Column in Excel?
- 3D Reference in Excel – What is it and How to Use it?
- How to Count Cells with Text in Excel?
- How to Add Minutes to Time in Excel?
- How to Remove Password From Excel?
- How to Select Visible Cells Only in Excel?
- How to Add Hours to Time in Excel?
- How to Clear Cache in Excel?
- How to Mark an Excel Workbook as Final?
- ALT+ENTER in Excel – What Does it Do?
- How to Open XML Files in Excel?
- What Does the Exclamation Point Mean in Excel?
- Remove Blank Rows in Excel (5 Ways + VBA)
- What Does F2 Do in Excel?
- ‘Does Not Equal’ Operator in Excel (Examples)
- How to Insert Date in Excel? (Shortcut + Formulas)
- How to Filter by Color in Excel?
- ALT + F4 in Excel – What Does it Do?
- How to Open DAT Files in Excel?
- Control E in Excel – What Does it Do?
- Round Up to the Nearest Whole Number in Excel (Formulas)
- COUNTIF Greater Than Zero in Excel
- How To Hide Formulas In Excel Without Protecting the Sheet?
- How to Convert PDF to Excel without Software?
- How to Combine Two Columns in Excel (with Space/Comma)
- How to Use Greater Than or Equal to Operator in Excel Formula?
- How to Select Non-adjacent Cells in Excel?
- How to Group Rows in Excel?
- How to Add Secondary Axis in Excel Charts?
- How to Freeze the Top Row and First Column in Excel?
- How to Round Time to the Nearest Quarter Hour in Excel?
- How to Remove First Character in Excel?
- How to Translate in Excel? (Text/Formulas)
- Subscript Out of Range Error in VBA – How to Fix!
- How to Copy Column Widths in Excel?
- Pivot Table Field Name is Not Valid – How to Fix?
- Row vs Column in Excel – What’s the Difference?
- How to Delete Defined Name in Excel? (Name Manager + VBA)
- How to Remove the Last Digit in Excel?
- How to Fix #NUM! Error in Excel?
- How to Convert Date to Serial Number in Excel?
- Switch First and Last Name with Comma in Excel (Reverse Names)
- How to Move Pivot Table in Excel?
- How to Remove Year from Date in Excel?
- How to Remove Blank Columns in Excel? (Formula + VBA)
- How to Rename a Table in Excel?
- How to Sort by Length in Excel? (Formula)
- How to Remove Borders in Excel?
- How to Remove Watermark in Excel (Image and Text)?
- How to Remove Question Marks from Text in Excel?
- How to Convert Columns to Rows in Excel?
- How to Apply Formula to Entire Column in Excel?
- How to Add a Percentage to a Number in Excel?
- How to Round to Nearest 100 in Excel?
- How to Copy and Paste in Excel Without Changing the Format?
- How to Separate Date and Time in Excel?
- How to Turn OFF Scroll Lock In Excel?
- How to Filter Multiple Columns in Excel?
- How to Change Commas to Decimal Points in Excel?
- Excel Not Responding – How To Fix It!
- VLOOKUP Not Working – 7 Possible Reasons + Fix!
- How to Edit Document Properties in Excel?
- How to Link Cells in Excel (Same Worksheet, Between Worksheets/Workbooks)
- How to Add Zero In Front of Number in Excel?
- How to Calculate the Interquartile Range in Excel?
- How To Combine Date and Time in Excel?
- How to Get the First Day Of The Month In Excel?
- How to Print Comments in Excel?
- How to Calculate Year-Over-Year (YOY) Growth in Excel (Formula)
- How to Sort a Pivot Table in Excel?
- Show Negative Numbers in Parentheses/Brackets in Excel
- How to Remove Table Formatting in Excel?
- How to Count Unique Values in Excel (Formulas)
- How to Refresh Pivot Table in Excel? (Shortcut + VBA)
- How to Highlight Dates Before Today in Excel?
- Calculate Days Between Two Dates in Excel (Workdays/Weekends)
- How to Rearrange Rows In Excel
- How to Add Border to a Chart in Excel?
- How to Calculate the Number of Months Between Two Dates in Excel?
- Remove Middle Name from Full Name in Excel
- How to Remove Scientific Notation in Excel
- How to Copy Row Height in Excel
- Excel Shortcuts Not Working – Possible Reasons + How to Fix?
- How to Change Date and Time to Date in Excel?
- How to Calculate Tiered Commission in Excel (Using IF/VLOOKUP)
- How to Get the Cell Address Instead Of Value In Excel?
- How to Remove Conditional Formatting in Excel?
- How to Change Font Color Based on Cell Value in Excel?
- How to Change Theme Colors in Excel?
- BETWEEN Formula in Excel
- Remove Grand Total From Pivot Table in Excel
- How to Clear Filter in Excel? Shortcut!
- How to Strikethrough in Excel (5 Ways + Shortcuts)
- Fill Blank Cells with 0 in Excel
- How to Delete Hidden Rows or Columns in Excel?
- Fill Blank Cells with Dash (-) in Excel
- How to Highlight Blank Cells in Excel?
- How to Subtract Percentage in Excel (Decrease Value by Percentage)?
- How to Show Ruler in Excel? (Excel Ruler Greyed Out)
- How to Insert Sheet Name into Header or Footer in Excel?
- Apply Comma Style Number Format in Excel
- How to Remove Gridlines in Excel (Shortcut + VBA)
- Formula Bar in Excel – Show/Hide Formula Bar!
- How to Remove Space before Text in Excel
- Why is Excel so Slow? How to Fix Slow Excel Files!
- What is an Active Cell in Excel?
- Microsoft Excel vs. Google Sheets – Which One Is Better for You?
- How To Go to the Top of the Page in Excel (Shortcuts)
- How to Paste without Formatting in Excel (Shortcuts)
- Press Enter and Stay in the Same Cell in Excel
- How to Add Calculated Field to Pivot Table?
- How to Remove Drop-down List in Excel?
- How to Add Developer Tab in Excel?
- How to Add Bullet Points in Excel
- Save Excel Chart as Image (High Resolution)
- Circular References in Excel – How to Find and Fix it!
- How to Compare Two Cells in Excel? (Exact/Partial Match)
- How to Calculate Cumulative Percentage in Excel?
- How to Add a Trendline in Excel Charts?
- How to Delete/Remove Checkbox in Excel?
- Get Unique Values from a Column in Excel
- How to Merge Two Excel Files?
- How to Delete a Pivot Table in Excel?
- SetFocus in Excel VBA – How to Use it?
- Weighted Average Formula In Excel (Examples)
- How to Separate Names in Excel
- How to Break Links To External References in Excel?
- Compound Interest Formula in Excel
- How to Calculate Percentage Difference in Excel (Formulas)
- How to Create a Waterfall Chart in Excel?
- How to Create Win/Loss Sparklines Chart in Excel?
- How to Group by Months in Excel Pivot Table?
- SPILL Error in Excel – How to Fix?
- Extract Last Name in Excel
- Find the Closest Match in Excel (Nearest Value)
- How to Delete Chart in Excel? (Manual & VBA)
- Count the Number of Yes in Excel (Using COUNTIF)
- How to Concatenate with Line Breaks in Excel?
- Can’t Type In Excel – How to Fix!
- Remove Parentheses (Brackets) in Excel
- How to Enter Sequential Numbers in Excel?
- How to Create Org Chart in Excel?
- How to Make Positive Numbers Negative in Excel?
- How to Make Box Plot (Box and Whisker Chart) in Excel?
- How to Remove Page Breaks in Excel?
- How to Flip Data in Excel (Columns, Rows, Tables)?
- How to Find Z-score in Excel?
- How to Get the p-Value in Excel?
- How to Convert a CSV File to Excel?
- How to Convert a Text File to Excel?
- How to Find the Last Space in Text String in Excel?
- Find Last Monday of the Month Date in Excel (Formula)
- How to Add Gridlines in a Chart in Excel?
- How to Insert Chart Title in Excel?
- How to Create Bar of Pie Chart in Excel?
- Excel Table vs. Excel Range – What’s the Difference?
- How to Apply Short Date Format in Excel?
- How to Move Row to Another Sheet Based On Cell Value in Excel?
- How to Extract Text After Space Character in Excel?
- How to Unmerge All Cells in Excel?
- How to Convert Month Name to Number in Excel?
- How to Remove Duplicate Rows based on one Column in Excel?
- Round UP or DOWN to Nearest 5 in Excel (Formula)
- How to Change All Caps to Lowercase Except the First Letter in Excel?
- How to Calculate Hours between two Times in Excel?
- How to Convert Decimal to Binary in Excel
- How to Separate Address in Excel?
- What is the Excel Personal Workbook Location?
- How to Calculate Confidence Interval in Excel
- Convert Military Time to Standard Time in Excel (Formulas)
- How to Bold Text using VBA in Excel
- What does Pound / Hash Symbol (####) Mean in Excel?
- How to Convert Days to Years in Excel (Formulas)
- How to Find Percentile in Excel (PERCENTILE Function)
- How to Make Excel File Read Only
- How to Find Slope in Excel (Formula)
- How to Switch Axis in Excel (Switch X and Y Axis)
- How to Autofill Dates in Excel (Autofill Months/Years)
- How to Create Barcodes in Excel
- How to Select Rows with Specific Text in Excel
- How to Calculate NPV in Excel (Net Present Value)
- How to Change Uppercase to Lowercase in Excel
- How to Calculate IRR with Excel
- How to Insert an Excel file into MS Word?
- How to Copy Formatting In Excel?
- How to Find Outliers in Excel?
- How to Extract Number from Text in Excel (Beginning, End, or Middle)
- Convert Bytes to MB or GB in Excel
- How to Replace Asterisks in Excel
- How to Remove Decimals in Excel?
- How to Change Page Orientation in Excel (for Printing)
- Using Application.GetSaveAsFilename in VBA in Excel (Examples)
- Using Conditional Formatting with OR Criteria in Excel
- Using IF Function with Dates in Excel (Easy Examples)
- How to Convert Month Number to Month Name in Excel
- Highlight Cell If Value Exists in Another Column in Excel
- How to Find Range in Excel (Formulas)
- How to Add a Total Row in Excel Table
- How to Select Multiple Rows in Excel?
- How to Apply Accounting Number Format in Excel
- How to Start Excel in Safe Mode?
- How to Find out What Version of Excel You Have?
- How to Square a Number in Excel?
- How to Hide Rows based on Cell Value in Excel?
- How to Remove Read-Only From Excel (Fix)
- 3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)
- How to Undo in Excel?
- How to Use Pi (π) in Excel
- How to Use ‘e’ in Excel? (Euler’s Number)
- How to Print Gridlines in Excel?
- How to Calculate Antilog in Excel (Formula)
- How to Save an Excel Table as Image?
- How to Remove Panes in Excel Worksheet (Shortcut)
- Excel Logical Test Using Multiple If Statements in Excel [AND/OR]
- How To Set Column Width in Inches (or Centimeters) in Excel?
- How to Find Duplicates in Excel (Conditional Formatting/ Count If/ Filter)
- How to Lock Cells in Excel [Mac, Windows]
- How to Open Excel File [xls, xlsx] Online (for FREE)
- How to Fill Blank Cells with Value above in Excel?
- 10 Best Excel Books (that will make you an Excel Pro)
- How to Compare Two Columns in Excel (using VLOOKUP & IF)
- How to Remove Formulas in Excel (and keep the data)
- Multiple If Statements in Excel (Nested IFs, AND/OR) with Examples
- How to Remove Dashes (-) in Excel?
- What does $ (dollar sign) mean in Excel Formulas?
- How to use Excel If Statement with Multiple Conditions Range [AND/OR]
- How to Hide Columns Based on Cell Value in Excel
- How to Flash an Excel Cell?
- How to Print Row Numbers in Excel?
- Why are Dates Shown as Hashtags in Excel?
- How to Save Selection in Excel as PDF?
- Why is Merge and Center Grayed Out?
- How to Sum Positive Numbers in Excel (Formula)
- How to Count Negative Numbers in Excel (Formula)
- How to Remove Macros from Excel?
- How to Convert Date to Day of Week in Excel?
- How to Convert Serial Numbers to Date in Excel
- How to Remove a Specific Character from a String in Excel
- How to Convert Date to Month and Year in Excel
- How to Move a Chart to a New Sheet in Excel
- How to Add Text to the Beginning or End of all Cells in Excel
- How to Remove Text after a Specific Character in Excel?
- Count How Many Times a Word Appears in Excel (Easy Formulas)
- How to Reverse a Text String in Excel (Using Formula & VBA)
- How to Remove Dotted Lines in Excel
- How to Convert Radians to Degrees in Excel (Easy Formula)
- How to Center the Worksheet Horizontally on the Page in Excel
- How to Add Cell Borders in Excel?
- How to Paste into Filtered Column Skipping the Hidden Cells?
- How to Generate Random Numbers in Excel (Without Duplicates)
- How to Fit to Page in Excel (Print on One Sheet)
- How to Merge First and Last Name in Excel?
- How to Split One Column into Multiple Columns in Excel
- How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)
- How to Add Days to a Date in Excel
- How to Format Phone Numbers in Excel
- How to Sort by Date in Excel (Single Column & Multiple Columns)
- How to Delete Filtered Rows in Excel (with and without VBA)
- How to Group and Ungroup Worksheets in Excel
- How to Remove Commas in Excel
- How to Set the Default Font in Excel (Windows and Mac)
- How to Remove Dollar Sign in Excel
- How to Remove Hyperlinks in Excel
- How to Remove Leading Zeros in Excel?
- How to Find Merged Cells in Excel?
- How to Insert Square Root Symbol in Excel?
- How to Calculate Standard Error in Excel?
- How to Highlight Every Other Row in Excel (Conditional Formatting & VBA)
- How to Filter as You Type in Excel (With and Without VBA)
- How to Select Alternate Columns in Excel (or every Nth Column)
- How to Subtract Multiple Cells from One Cell in Excel
- How to Copy Multiple Sheets to a New Workbook in Excel
- How to Delete a Sheet in Excel Using VBA
- How to Select Every Other Cell in Excel (Or Every Nth Cell)
- How to Convert Decimal to Fraction in Excel
- Why does Excel Open on Startup (and How to Stop it)
- SUMPRODUCT vs SUMIFS Function in Excel
- How to Remove Apostrophe in Excel?
- Excel Showing Formula Instead of Result
- How to Auto Format Formulas in Excel?
- How to Print Multiple Tabs/Sheets in Excel
- How to Unhide All Rows in Excel with VBA
- Using Application.EnableEvents in VBA in Excel (Examples)
- How to Clear Contents in Excel without Deleting Formulas
- How to Delete a Comment in Excel (or Delete ALL Comments)
- How to Unsort in Excel (Revert Back to Original Data)
- How to Extract URL from Hyperlinks in Excel (Using VBA Formula)
- How to Set a Row to Print on Every Page in Excel