Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros

Excel Tips

Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.

How to Convert Decimal to Fraction in Excel

Change fraction format to Up to two digits

Ever opened an Excel Sheet and felt completely put off by a sheet laden with decimal points? If you feel that way about decimals, you’re not alone. In fact, a …

Read more

Why does Excel Open on Startup (and How to Stop it)

Excel Task Manager - Why does Excel Open on Startup (and How to Stop it)

If you are using MS Excel on a Windows 10 Operating system, you might have come across this problem of your computer automatically starting MS Excel at startup. This is …

Read more

How to Remove Apostrophe in Excel (3 Easy Ways)

Remove Apostrophe in Excel using Text to Columns

You might have come across Excel documents created by someone else that contains the apostrophe symbol in front of text, numbers, or dates. You might have also noticed this happening …

Read more

Excel Showing Formula Instead of Result (How to FIX!)

Select General as the format

Sometimes, it may happen that your Excel workbook shows formulas instead of the result. Something as shown below: But there is no need to panic… All’s well! This is something …

Read more

How to Auto Format Formulas in Excel (3 Easy Ways)

Autoformat Formulas result after using conditional formatting

When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …

Read more

How to Print Multiple Tabs/Sheets in Excel (Step-by-Step)

Click the Print button

Excel has the option to print the active sheet, any selection on the active sheets as well as the entire workbook. But what if you want to print multiple sheets …

Read more

How to Clear Contents in Excel without Deleting Formulas

Click on Clear All

Excel allows you to clear content in the worksheets selectively. So, you can clear the contents in all the cells except the ones that have formulas. This can be useful …

Read more

How to Delete a Comment in Excel (or Delete ALL Comments)

Click on Clear Commnents and Notes

Comments in Excel are great when you’re working with multiple people and need to tag a few cells with some important notes. And with comments, you can have multiple people …

Read more

How to Unsort in Excel (Revert Back to Original Data)

Data that need to be sorted and then unsorted

Data sorting is one of the most common tasks people do in Excel. But what if you want to un-sort in Excel – i.e., is to revert back to the …

Read more

How to Set a Row to Print on Every Page in Excel

Select the row that you want to repeat

If you often print your work in Excel, you would benefit from knowing how to make sure a row (or multiple rows) print on every page that you print. This …

Read more

Post navigation
Newer posts
← Previous Page1 … Page12 Page13

Most Popular Articles

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2022 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status