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.
-
Round UP or DOWN to Nearest 5 in Excel (Formula)
-
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?
-
What is the Excel Personal Workbook Location?
-
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 (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?
Looking for something specific? Use the search icon in the main navigation or visit the site search page.