Excel Flash Fill Not Working – How to Fix?
Flash Fill can turn one example into a completed column, saving you from typing or copying the same pattern row by row. When it stops working, the cause is usually …
Steve Scott
How to Convert Julian Date to Calendar Date in Excel (5-Digit, 7-Digit, and JDE)
Converting a Julian date in Excel turns a compact year and day code into a calendar date you can read, sort, and filter. Before choosing a formula, count the digits …
Pivot Table Not Refreshing – How to Fix?
When a PivotTable does not refresh, its report can keep old totals or omit newly added records. A basic refresh works only when Excel can read the right source and …
How to Use Custom AutoFilter in Excel (AND/OR Conditions and Wildcards)
When a regular filter checklist isn’t specific enough, Custom AutoFilter lets you filter a column with operators such as Contains, Begins With, Between, and After. That helps when you’re looking …
How to Create an Aging Formula in Excel (30, 60, 90 Days)
An aging report sorts unpaid invoices by how many days they are past due. It shows which balances are current and which ones need attention. Excel can calculate the late …
How to Make Tally Marks in Excel
Tally marks give you a quick visual count of votes, survey answers, attendance, or anything else you record repeatedly. Excel has no dedicated tally button. However, a couple of formulas …
How to Use SUMIFS with INDEX MATCH in Excel
SUMIFS is a useful function when you want to add up values that meet one or more conditions, like sales for the West region. It works fine when the numbers …
Input Cell Reference Is Not Valid in Excel – How to Fix?
When you build a data table in Excel, you may run into an error that stops it before it starts. The message is: Input cell reference is not valid. It …
Unshare Workbook Grayed Out in Excel – How to Fix?
Sometimes you may find that the Unshare Workbook button is grayed out, so you cannot stop sharing the workbook in the usual way. In a current Microsoft 365 build, that …
How to Make a Copy of an Excel File
If you want to make a copy of an Excel file, you probably want to keep the original safe while you work on a duplicate. Maybe you’re reusing last month’s …
How to Use Goal Seek in Excel
What price gives you a 30% margin after fees? How many production batches cover an order? How much customer churn can you afford? Goal Seek in Excel answers these questions …
Excel File Extensions Explained (.XLSX, .XLS, .XLSM, .XLSB, .CSV)
If you want to know what .xlsx, .xls, or .xlsm means, look at the file extension at the end of the name. It tells Excel and Windows what kind of …