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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 encounter 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 …
How to Add Comma Between Names in Excel
Adding a comma between names in Excel can be laborious and time-consuming if done manually, especially if you have a lot of data. Doing it manually also increases the chances …
How To Highlight Weekends In Excel?
When working with dates in Excel, we can highlight weekend dates to visually distinguish them from weekdays or to emphasize their non-working status. The highlighting can be handy in situations …
How to Remove Strikethrough in Excel?
The strikethrough format is commonly used in Excel to indicate that a value, formula, or cell reference is no longer relevant or that a particular item or task has been …
How to Group by Quarters in Excel Pivot Table?
Grouping by quarters in an Excel Pivot Table can help you to summarize and analyze data more effectively. Additionally, it can make it easier to identify significant patterns and trends …