How to Lock a Row in Excel
If you want to lock a row in Excel, the first thing to work out is which kind of locking you actually mean. The phrase covers three completely different jobs, …
Steve Scott
Calculate Growing Annuity in Excel
A growing annuity is a series of payments made at regular intervals, each payment increasing at a fixed rate over time. Excel doesn’t have a built-in function for calculating a …
Calculate CHI-SQUARE in Excel
Chi-Square measures how far observed values differ from expected values. It tells you whether the difference is real or just a random chance. In Excel, you can calculate the Chi-Square …
Excel Filter Not Working – How to Fix?
When Excel’s filter stops working, you may find that filter buttons are missing, the criteria don’t apply correctly, or Excel only filters part of your data. In this tutorial, I …
How to Generate Random Dates in Excel
You might need to generate random dates between two dates in Excel, for example, when creating a sample set of transaction dates to test formulas. I will show you how …
List All Dates Between Two Dates in Excel
If your work involves tracking attendance, building project timelines, creating schedules, or similar tasks, knowing how to generate a list of all dates between two dates in Excel is a …
How to Add Years to a Date in Excel
If your Excel work includes calculating contract end dates, retirement dates, or similar timelines, knowing how to add years to a date can simplify your work. I will show you …
How to Remove Header and Footer in Excel
You should remove the headers and footers from your Excel reports when they add no value to the printed document or make it look cluttered and unprofessional. As shown in …
How to Shift Cells Down in Excel (8 Easy Ways)
When working with Excel, you may sometimes want to rearrange your data and shift some cells down to make room for new cells. There are multiple ways to do this, …
How to Use Wildcard in XLOOKUP
Want to supercharge your Excel lookups? Wildcards in XLOOKUP let you match fragments of text, hunt down partial entries, and return accurate results even when you don’t know the full …
Create a Drop-down List with Color in Excel
When you create a drop-down list in Excel, it only displays text options. But sometimes you may want it to show colors, too. Although you can’t display colors in the …
How to Convert Minutes to Hundredths in Excel
If you want to use minutes data in Excel in arithmetic calculations, you need to first convert it into hundredths in Excel. And this is because Excel stores dates and …