Excel Blog - Latest Excel tips, tutorials, and videos.

0 How to Remove Line Breaks in Excel (3 Easy Ways)

formula to remove line breaks with comma and space in Excel

If you work with data that is imported from databases or salesforce, you’ve probably already dealt with line breaks. A line break is something that allows you to have multiple lines in the same cell in Excel. Below is an example of a name and address dataset wherein a single line, name and different parts […]

0 How to Turn On AutoSave in Excel (An Easy Guide)

While Excel has been continuously improved with each new version, there are still times when you may find it crashing once in a while (especially if you’re working with a large dataset). And sometimes, it could be a factor outside of Excel – such as a power failure or your system hanging because of an […]

0 How to Delete Entire Row in Excel Using VBA (Examples)

Copy and paste to delete entire row in the module

Adding and deleting rows is part of everyday common tasks when working with Excel. While you can do this easily from the worksheet itself, sometimes you may want to use the VBA route to delete rows in Excel. These could be deleting a specific row, multiple rows in the selection, deleting alternate rows or those […]

2 Excel Filter Function – Explained with Examples + Video

Watch Video – Excel FILTER Function Examples Office 365 brings with some awesome functions – such as XLOOKUP, SORT, and FILTER. When it comes to filtering data in Excel, in the pre-Office 365 world, we were mostly dependent on Excel in-built filter or at max the Advanced filter or complex SUMPRODUCT formulas. In case you […]

0 How to Save Excel Charts as Images (save as PNG, JPG, BMP)

Watch video – Save Excel Charts as Images/Pictures Excel has a lot of useful in-built charts and you can also combine and create some amazing combination charts as well. Excel charts are a great way to show your data visually and are often the most used ones when you have to present it to your […]

6 Excel XLOOKUP Function: All You Need to Know (10 Examples)

formula to fetch the name with highest score

Watch Video – Excel XLOOKUP Function (10 XLOOKUP Examples) Excel XLOOKUP function has finally arrived. If you have been using VLOOKUP or INDEX/MATCH, I am sure you’ll love the flexibility that the XLOOKUP function provides. In this tutorial, I will cover everything there is to know about the XLOOKUP function and some examples that will […]

0 How to Remove Table Formatting in Excel (Easy Guide)

Excel Table is an amazing feature that makes working with data a lot easier. And as more advanced tools such as Powe Query and Power Pivot now rely on Excel tables to be the data source, Excel tables are going to become even more important. But this tutorial is not about the awesomeness of Excel […]

1 2 3 … 56 Next »