Explore Spreadsheet Planet
Find any tutorial.
Browse by topic or scan the complete article archive below. Use the pagination to move through every published guide.
Browse popular topics
All tutorials
The newest articles appear first. This list updates automatically whenever a new tutorial is published.
-
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?
Looking for something specific? Use the search icon in the main navigation or visit the site search page.