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

0 How to Print Multiple Sheets (or All Sheets) in Excel in One Go

Excel gives you a lot of options when you’re trying to print your work. You can choose to print the entire worksheet, a specific area in the worksheet, print multiple sheets, or all sheets at one go. In this tutorial, I will show you how you can print multiple sheets in Excel at one go. […]

0 5 Ways to Insert New Columns in Excel (including Shortcut & VBA)

Adding or removing columns in Excel in a common task when you’re working with data in Excel. And just like every other thing in Excel, there are multiple ways to insert columns as well. You can insert one or more single columns (to the right/left of a selected one), multiple columns (adjacent or non-adjacent), or […]

0 How to Add Error Bars in Excel (Horizontal/Vertical/Custom)

When you represent data in a chart, there can be cases when there is a level of variability with a data point. For example, you can not (with 100% certainty) predict the temperature of the next 10 days or the stock price of a company in the coming week. There will always be a level […]

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 […]

1 2 3 … 57 Next »