This page has all the articles published on Spreadsheet Planet
Posts by category
- Category: Charts
- How to Add Secondary Axis in Excel Charts?
- How to Add Border to a Chart in Excel (4 Easy Ways)
- Save Excel Chart as Image (High Resolution) – 4 Easy Ways!
- How to Add a Trendline in Excel Charts? Step-by-Step!
- How to Create a Waterfall Chart in Excel?
- How to Create Win/Loss Sparklines Chart in Excel?
- How to Delete Chart in Excel? (Manual & VBA)
- How to Create Org Chart in Excel? Easy Method
- How to Make Box Plot (Box and Whisker Chart) in Excel?
- How to Add Gridlines in a Chart in Excel? 2 Easy Ways!
- How to Insert Chart Title in Excel? 2 Easy Ways
- How to Create Bar of Pie Chart in Excel? Step-by-Step
- How to Switch Axis in Excel (Switch X and Y Axis)
- How to Move a Chart to a New Sheet in Excel
- Category: Excel Tips
- 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? (10 Hacks)
- COUNTIF Greater Than Zero in Excel
- How to Insert Degree Symbol 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 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)
- 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?
- #NUM! Error in Excel – How to Fix it?
- 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? 3 Quick Ways!
- How to Sort by Length in Excel? Easy Formula!
- How to Remove Borders in Excel? 6 Easy Ways!
- 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? 6 Easy Ways!
- How to Copy and Paste in Excel Without Changing the Format? 5 Ways!
- How to Separate Date and Time in Excel (7 Easy Ways)
- How to Turn OFF Scroll Lock In Excel? 2 Easy Ways!
- How to Filter Multiple Columns in Excel? 3 Easy Ways!
- How to Change Commas to Decimal Points in Excel? 5 Easy Ways!
- Excel Not Responding – 10 Ways 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 (7 Easy Ways)
- How to Calculate the Interquartile Range in Excel (Easy Formula)
- How To Combine Date and Time in Excel (3 Easy Ways)
- How to Get the First Day Of The Month In Excel? (3 Easy Formulas)
- How to Print Comments in Excel? 4 Easy Ways!
- How to Calculate Year-Over-Year (YOY) Growth in Excel (Formula)
- How to Sort a Pivot Table in Excel (2 Quick Ways)
- Show Negative Numbers in Parentheses/Brackets in Excel (2 Easy Methods)
- How to Remove Table Formatting in Excel? 3 Easy Ways!
- How to Count Unique Values in Excel (5 Formulas Methods)
- 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 (4 Easy Ways)
- How to Calculate the Number of Months Between Two Dates in Excel?
- Remove Middle Name from Full Name in Excel (6 Easy Ways)
- How to Get Rid of Scientific Notation in Excel (7 Simple Methods)
- How to Copy Row Height in Excel (5 Easy Ways)
- Excel Shortcuts Not Working – Possible Reasons + How to Fix?
- How to Change Date and Time to Date in Excel (4 Easy Ways)
- How to Calculate Tiered Commission in Excel (Using IF/VLOOKUP)
- How to Get the Cell Address Instead Of Value In Excel? (Easy Formulas)
- How to Remove Conditional Formatting in Excel? (5 Easy Ways)
- How to Change Font Color Based on Cell Value in Excel?
- How to Change Theme Colors in Excel? Step-by-Step!
- BETWEEN Formula in Excel (Using IF Function) – Examples
- Remove Grand Total From Pivot Table in Excel (Easy Steps)
- How to Clear Filter in Excel? Shortcut!
- How to Strikethrough in Excel (5 Ways + Shortcuts)
- Fill Blank Cells with 0 in Excel (3 Easy Ways)
- How to Delete Hidden Rows or Columns in Excel? 2 Easy Ways!
- Fill Blank Cells with Dash (-) in Excel (3 Easy Ways)
- How to Indent in Excel? (Easy Shortcut)
- How to Highlight Blank Cells in Excel? 3 Easy Methods!
- How to Subtract Percentage in Excel (Decrease Value by Percentage)?
- How to Show Ruler in Excel? (Ruler Grayed Out)
- How to Insert Sheet Name into Header or Footer in Excel?
- How to Apply Comma Style Number Format in Excel (3 Easy Ways)
- How to Remove Gridlines in Excel (Shortcut + VBA)
- Formula Bar in Excel – Show/Hide Formula Bar!
- How to Remove Space before Text in Excel (5 Easy Tricks)
- Why is Excel so Slow? 11 Tips 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)
- How to Press Enter in Excel and Stay in the Same Cell? 3 Ways!
- How to Add Calculated Field to Pivot Table?
- How to Remove Drop-down List in Excel? 3 Easy Ways!
- How to Add Developer Tab in Excel? 2 Easy Ways!
- How to Add Bullet Points in Excel (7 Easy Ways)
- 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? 3 Easy Ways!
- How to Delete/Remove Checkbox in Excel?
- Get Unique Values from a Column in Excel – 3 Easy Ways!
- How to Merge Two Excel Files? 3 Easy Ways!
- How to Delete a Pivot Table? 4 Different Ways!
- Weighted Average Formula In Excel (Easy Examples)
- How to Separate Names in Excel (5 Easy Ways)
- How to Break Links To External References in Excel? (2 Easy Ways)
- Compound Interest Formula in Excel (2 Easy Ways)
- How to Calculate Percentage Difference in Excel (Formulas)
- How to Group by Months in Excel Pivot Table?
- SPILL Error in Excel – How to Fix?
- Extract Last Name in Excel – 4 Easy Ways!
- Find the Closest Match in Excel (Nearest Value) – Easy Formula
- Count the Number of Yes in Excel (Using COUNTIF)
- How to Concatenate with Line Breaks in Excel? 3 Easy Ways
- Can’t Type In Excel: 6 Possible Reasons and Solutions!
- Remove Parentheses (Brackets) in Excel – 3 Easy Ways
- How to Enter Sequential Numbers in Excel? 4 Easy Ways!
- How to Make Positive Numbers Negative in Excel (3 Easy Ways)
- How to Remove Page Breaks in Excel? Quick and Easy!
- How to Flip Data in Excel (Columns, Rows, Tables)?
- How to Find Z-score in Excel? Easy Formula
- How to Get the p-Value in Excel? 2 Easy Ways!
- 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 (Easy Formula)
- Excel Table vs. Excel Range – What’s the Difference?
- How to Apply Short Date Format in Excel? 3 Easy Ways!
- 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? 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 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)
- 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 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
- Subscript Out of Range Error in VBA – How to Fix!
- How to Open Excel Files Using VBA (Examples)
- SetFocus in Excel VBA – How to Use it?
- 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 to the Nearest Whole Number in Excel (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: Charts