This page has all the articles published on Spreadsheet Planet
All Tips and Tutorials
- 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 2020)
- 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 (Easy Step-by-Step Method)
- 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 Remove Macros from Excel? 3 Simple Methods
- 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 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 (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 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 (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 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 (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 Calculate Standard Error in Excel (Step-by-Step)
- 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 (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 Unhide All Rows in Excel with VBA
- Using Application.EnableEvents in VBA in Excel (Explained with 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
