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

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?
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

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