How to Use Slicers in Excel (Beginner to Advanced Guide)
Slicers in Excel turn a PivotTable or Table filter into a set of buttons. Click East, and the report shows East. Click West, and it switches. That’s easier than opening …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Status Bar in Excel: Where It Is, What It Shows, and How to Customize It
The status bar in Excel is the thin strip at the bottom of the window, and it can total, average, or count any cells you select without a formula. It …
New Excel Functions in Microsoft 365 (With Examples)
Excel has picked up a lot of new functions over the last few years. If you only know XLOOKUP and maybe FILTER, you’re missing some really handy ones. In this …
How to Use Cell Styles in Excel
Cell Styles let you give titles, totals, inputs, warnings, and other worksheet elements consistent formatting without rebuilding that formatting one piece at a time. A style can control the font, …
Fixed Objects Will Move in Excel: How to Fix It
The “Fixed objects will move” warning can interrupt filtering or saving in Excel. It concerns worksheet objects, which can include pictures, buttons, shapes, and older cell notes. The awkward part …
How to Fix the Name Conflict Dialog Box in Excel?
The Name Conflict dialog is blocking your sheet copy, and resolving one conflict brings up another prompt for the next conflicting name. Yes to All ends that loop, but it …
Excel Automatic Update of Links Has Been Disabled: How to Fix?
Excel shows the yellow “Automatic update of links has been disabled” bar when a workbook pulls information from another file and Excel pauses that connection for safety. Until you allow …
How to Fix the “Cannot Insert Object” Error in Excel
Excel’s “Cannot insert object” error can appear when you embed a file or add an ActiveX control. The fix depends on which object you’re inserting. On current Microsoft 365 builds, …
Excel Find and Replace Not Working – How to Fix?
Excel Find and Replace helps you locate text, numbers, formulas, and formatting, then update the matching cells. When it stops working, the cause is usually a selected range, a saved …
How to Show the Difference Between Two Columns in a Pivot Table
A PivotTable can show the gap between two columns without changing your source data. The trick is knowing what those columns represent. If you are comparing January and February under …
How to Do a Fuzzy Lookup in Excel
Misspelled names and inconsistent spacing can turn an ordinary lookup into a blank result, even when both records refer to the same place or person. A fuzzy lookup compares text …
Pivot Table vs Pivot Chart in Excel
A pivot table summarizes a big dataset into a small table of totals, counts, or averages. A pivot chart takes that same summary and draws it as a chart. Both …