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 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?
Looking for something specific? Use the search icon in the main navigation or visit the site search page.