Arrow Keys Not Working in Excel (Not Moving Between Cells) – FIXED!
If you want to move between cells with the arrow keys and Excel refuses to budge, the problem is almost never your keyboard. And this is because Excel has a …
Steve Scott
How to Move Columns in Excel
If you want to move a column in Excel so it sits somewhere else in your table, you cannot just drag it across and drop it. A plain drag lands …
How to Check If a Cell Contains Text in Excel?
If you want to do something when a cell contains a certain word, you cannot just use =IF(C2=”urgent”,”Rush”,”Standard”). And this is because that test asks whether the cell IS urgent, …
How to Highlight Duplicates in Excel
If you want to spot the repeated entries in an Excel sheet, coloring them in is the fastest way to see what you’re dealing with. But Excel’s built-in rule compares …
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, …
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 …