This page has all the articles published on Spreadsheet Planet
Posts by category
- Category: Excel Tips
- How to Extract Text After Space Character in Excel?
- How to Unmerge All Cells in Excel? 3 Simple Ways
- How to Convert Month Name to Number in Excel?
- How to Remove Duplicate Rows based on one Column in Excel?
- 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?
- 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 (Simple Formulas)
- How to Find Percentile in Excel (PERCENTILE Function)
- How to Make Excel File Read Only
- How to Find Slope in Excel (Easy 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 (Easy Step-by-Step)
- 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 (3 Easy Ways)
- How to Calculate IRR with Excel (easy Examples)
- How to Insert an Excel file into MS Word (3 Easy Ways)
- How to Copy Formatting In Excel (4 Easy Ways)
- How to Find Outliers in Excel (3 Easy Ways)
- How to Extract Number from Text in Excel (Beginning, End, or Middle)
- Convert Bytes to MB or GB in Excel (2 Easy Ways)
- How to Replace Asterisks in Excel (2 Easy Ways)
- How to Remove Decimals in Excel (3 Easy Ways)
- 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 (2 Easy Formulas)
- How to Add a Total Row in Excel Table (Easy Step-by-Step)
- How to Select Multiple Rows in Excel (3 Easy Ways)
- How to Apply Accounting Number Format in Excel
- How to Start Excel in Safe Mode (3 Easy Ways)
- How to Find out What Version of Excel You Have (Easy Way)
- How to Square a Number in Excel (2 Simple Methods)
- How to Hide Rows based on Cell Value in Excel (2 Easy Methods)
- How to Remove Read-Only From Excel (6 Easy Fix)
- 3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)
- How to Undo in Excel (2 Easy Ways)
- How to Use Pi (π) in Excel
- How to Use e in Excel | Euler’s Number in Excel
- How to Print Gridlines in Excel (3 Easy Ways)
- How to Calculate Antilog in Excel (Easy Formula)
- How to Save an Excel Table as Image (4 Easy Ways)
- 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 (3 Easy Ways)
- 10 Best Excel Books (that will make you an Excel Pro in 2021)
- How to Compare Two Columns in Excel (using VLOOKUP & IF)
- How to Remove Formulas in Excel (and keep the data)
- How to Remove Dashes (-) in Excel?
- What does $ (dollar sign) mean in Excel Formulas?
- How to Print Row Numbers in Excel (3 Easy Ways)
- Why are Dates Shown as Hashtags in Excel? Easy Fix!
- How to Save Selection in Excel as PDF (3 Easy Methods)
- Why is Merge and Center Grayed Out?
- How to Sum Positive Numbers in Excel – Easy Formula
- How to Count Negative Numbers in Excel – Easy Formula
- How to Convert Date to Day of Week in Excel (3 Easy Ways)
- 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 (3 Easy Ways)
- 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 (3 Easy Methods)
- How to Remove Dotted Lines in Excel
- How to Center the Worksheet Horizontally on the Page in Excel (3 Easy Ways)
- How to Add Cell Borders in Excel (3 Easy Ways)
- How to Paste in a Filtered Column Skipping the Hidden Cells
- How to Fit to Page in Excel (Print on One Sheet)
- How to Merge First and Last Name in Excel (2 Easy Ways)
- 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 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 (from Numbers or Text String)
- How to Set the Default Font in Excel (Windows and Mac)
- How to Remove Dollar Sign in Excel (4 Easy Ways)
- How to Remove Hyperlinks in Excel (Easy Step-by-Step)
- How to Remove Leading Zeros in Excel (3 Easy Ways)
- How to Find Merged Cells in Excel (2 Simple Ways)
- How to Insert Square Root Symbol in Excel (5 Easy Ways)
- 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 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)
- How to Remove Apostrophe in Excel (3 Easy Ways)
- Excel Showing Formula Instead of Result (How to FIX!)
- How to Auto Format Formulas in Excel (3 Easy Ways)
- How to Print Multiple Tabs/Sheets in Excel (Step-by-Step)
- 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 Set a Row to Print on Every Page in Excel
- Category: Excel VBA / Macros
- What is the Excel Personal Workbook Location?
- How to Hide Columns Based on Cell Value in Excel
- How to Flash an Excel Cell (Easy Step-by-Step Method)
- How to Remove Macros from Excel? 3 Simple Methods
- How to Delete a Sheet in Excel Using VBA
- How to Unhide All Rows in Excel with VBA
- Using Application.EnableEvents in VBA in Excel (Explained with Examples)
- How to Extract URL from Hyperlinks in Excel (Using VBA Formula)
- Category: Formulas
- Round UP or DOWN to Nearest 5 in Excel (Easy Formula)
- Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples
- How to use Excel If Statement with Multiple Conditions Range [AND/OR]
- How to Count How Many Times a Word Appears in Excel (Easy Formulas)
- How to Reverse a Text String in Excel (Using Formula & VBA)
- How to Convert Radians to Degrees in Excel (Easy Formula)
- How to Generate Random Numbers in Excel (Without Duplicates)
- How to Add Days to a Date in Excel
- How to Calculate Standard Error in Excel (Step-by-Step)
- SUMPRODUCT vs SUMIFS Function in Excel
- Category: Excel Tips