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.

View XML sitemap

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
How to Set the Default Font in Excel (Windows and Mac)
How to Remove Dollar Sign in Excel
How to Remove Hyperlinks in Excel
How to Remove Leading Zeros in Excel?
How to Find Merged Cells in Excel?
How to Insert Square Root Symbol in Excel?
How to Calculate Standard Error in Excel?
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?
Excel Showing Formula Instead of Result
How to Auto Format Formulas in Excel?
How to Print Multiple Tabs/Sheets in Excel
How to Unhide All Rows in Excel with VBA
Using Application.EnableEvents in VBA in Excel (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

Looking for something specific? Use the search icon in the main navigation or visit the site search page.