How to Turn OFF Flash Fill in Excel
Excel Flash fill helps quickly fill our Excel data by identifying a pattern and using the same pattern to fill the data in a column. For it to work, you …
Steve Scott
Copy Conditional Formatting in Excel
When working in Excel, it is normal practice to copy conditional formatting from one cell to another. It saves us time because we don’t have to create the same conditional …
How to Replace Zero with Dash in Excel?
When making reports in Excel, it’s important to show information in a way that’s easy to read and understand. Sometimes, having lots of zeros in the report can make it …
Convert Days to Months in Excel
Whether managing a project or tracking personal milestones, converting days to months in Excel can be useful. With simple formulas, you can easily transform any given number of days into …
Smooth Scrolling in Excel
In August 2021, Microsoft Excel released the much-needed smooth scrolling feature. The feature allows you to use the mouse’s scroll wheel or the program’s scroll bars to scroll one line …
To Do this All Merged Cells Need to be the Same Size – Fix!
Merging cells in Microsoft Excel can be a helpful feature to organize and display your data. But sometimes, while working with data in Excel, you may get the warning message …
Microsoft Excel is Waiting for Another Application to Complete an OLE Action – Fix!
Have you ever encountered the frustrating “Microsoft Excel is waiting for another application to complete an OLE action” error message? If so, you’re not alone. This error can bring your …
How to Calculate Growth Rate in Excel
Calculating growth rates in Excel is a valuable skill for various purposes, such as business, finance, and personal growth tracking. By learning how to calculate growth rates, you can identify …
How to Clear Pivot Table Cache?
When we edit the source data of a Pivot Table, it will not automatically update in our Pivot Table. When we create a Pivot Table, Excel creates a replica of …
XLS vs. XLSX Files – What’s the Difference?
When working with Microsoft Excel, you might have come across two different file formats, namely XLS and XLSX. Understanding the difference between these two formats can help you make better …
How to Remove Leading Spaces in Excel?
When working with Excel, you may entcounter situations where unwanted leading spaces appear in your data. Leading spaces refer to spaces that are added at the beginning of text strings …
How to Extract First Name in Excel
Sometimes when working with data such as employee or student records, your datasets will contain full names. However, you may only need a specific part of the full name for …