Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
    • Excel Functions
    • Formulas Tricks
    • Charts
    • Shortcuts
  • Excel VBA
  • Power Query
  • Calculators
  • Newsletter

Excel Tips

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

Calculate Days Between Two Dates in Excel (Workdays/Weekends)

Calculate Days Between Two Dates in Excel (WorkdaysWeekends)

Calculating the number of days between two dates in Excel is a popular operation performed in different scenarios.  For example, project managers use it to measure performance against milestones, and …

Read more

How to Rearrange Rows In Excel

How to Rearrange Rows In Excel

While working in Microsoft Excel, you may have a need to rearrange rows in order to show the data the right way. In this tutorial, I will show you some …

Read more

How to Calculate the Number of Months Between Two Dates in Excel?

How to Calculate the Number of Months Between Two Dates in Excel

Sometimes you may want to find out the number of months between two dates. For example, if you are a project manager, you may want to find out how many …

Read more

Remove Middle Name from Full Name in Excel

Remove Middle Name from Full Name in Excel

There may be times when you are given a full name and need to remove the middle name so that you are left with the first and last name only. …

Read more

How to Remove Scientific Notation in Excel

How to Get Rid of Scientific Notation in Excel

While Excel is built to work with large numbers, when you enter a number that has more than 11 digits, you would notice that these are converted into scientific notation …

Read more

How to Copy Row Height in Excel

How to Copy Row Height in Excel

We often came across a situation where we want to copy the row height from one row and apply the same to other rows.  It would be quite tedious to …

Read more

Excel Shortcuts Not Working – Possible Reasons + How to Fix?

Excel Shortcuts Not Working – Possible Reasons + How to Fix

Shortcuts refer to the combination of keys used to complete repetitive tasks instead of scrolling through various ribbons to achieve the same objective. These shortcuts come in handy when you …

Read more

How to Change Date and Time to Date in Excel?

How to Change Date and Time to Date in Excel

A lot of times, when I download data from a database or from the web, it has the time as well as the date in the same cell. And many …

Read more

How to Calculate Tiered Commission in Excel (Using IF/VLOOKUP)

How to Calculate Tiered Commission in Excel (Using IFVLOOKUP)

Tiered commissions are quite common for people who do sales. Tiered commissions provide an incentive for salespeople to boost their sales figures in order to earn more commission. This, in …

Read more

How to Get the Cell Address Instead Of Value In Excel?

How to Get Rid of Scientific Notation in Excel

In Excel, we often use formulas like INDEX/MATCH, VLOOKUP, and XLOOKUP to match the lookup value but in some scenarios, we came across a situation in which we lookup for …

Read more

How to Remove Conditional Formatting in Excel?

How to Remove Conditional Formatting in Excel

The Conditional Formatting feature provides an excellent way to highlight or draw attention to data that meets certain criteria or conditions. It is an effective visual communication technique. Spreadsheet designers …

Read more

How to Change Font Color Based on Cell Value in Excel?

How to Change Font Color Based on Cell Value in Excel

I have seen many people manually change the cell’s font color based on the cell value. While this is all right if you have to do it once in a …

Read more

Older posts
Newer posts
← Previous Page1 … Page38 Page39 Page40 … Page54 Next →

MOST POPULAR ARTICLES

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

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

How to Remove Dashes (-) in Excel?

Center the Worksheet Horizontally on the Page in Excel

Merge First and Last Name in Excel

Remove Commas in Excel (from Numbers or Text String)

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

Remove Apostrophe in Excel

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

Microsoft Excel Terminology (Glossary)

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

2026 © spreadsheetplanet.com Privacy Policy | Terms of Service | Refund Policy | Sitemap | Contact Us

DMCA.com Protection Status