This article explains how to group worksheets in Excel. You may want to do this to quickly edit multiple worksheets simultaneously, perform the same calculation on multiple sheets, correct typos, or copy a group of sheets. To group sheets in Excel: Hold down the CTRL key and click each of the tabs one by one When you […]

Adding colors and number formatting can improve the readability of your Excel reports, but sometimes you will want to remove all the formatting and start over. This is why it is essential to learn how to clear formatting in Excel as quickly as possible (we also want to be efficient, right?). How to clear all […]

This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide flexibility if you want to create a nice and structured presentation, but when it comes to usability, in most […]

Excel is great at manipulating and sharing data, but it sure doesn’t shine when it comes to text formatting. However, simple changes like indenting text can significantly improve readability. In this short Excel tutorial, I will show you how to indent In Excel. Indent using Ribbon Options By default, Excel aligns text strings to the left […]

Learn how to hide sheets in Excel using three different ways: with the mouse right-click, using the ribbon, or using a keyboard shortcut. Why would you need to hide a worksheet in Excel? Well, maybe you have some source data, and you don’t want it to be visible, or you simply want to keep all […]

If you are working on a shared workbook, you may want to protect all or some of the cells to prevent unwanted changes from other users. This is also valid if you’re going to send a report and you don’t want people modifying it or changing the file structure or the formulas. That is why […]

When you work with a large spreadsheet containing a lot of text that needs to be displayed, long sentences or data strings will either spill over on top of other empty cells on the right or cut off at the cell border if the adjacent cell contains data. This is why it’s important to learn […]

Sometimes, the data in your spreadsheet may not be formatted as you need it to be. Removing extra characters can be tedious, and doing it manually is time-consuming and prone to error. Luckily, there are easy ways to manipulate data using Excel functions and formulas. In this article, you will learn how to remove last […]

The Freeze Panes option allows you to lock certain rows, so they remain fixed and are always visible when you scroll down. The tutorial shows step-by-step instructions on how to freeze a row in Excel. You can apply the same steps to freeze multiple rows or columns. I’ll explain each option. How to freeze rows […]

This tutorial shows how to remove password from Excel files using multiple methods. Some methods work even if you don’t know the password. Whenever you send out an Excel file that you don’t want to be changed, it’s essential to protect the worksheets with a password. However, you will also need to be able to […]

The tutorial explains how to merge Excel files by copying sheets or running a VBA code. It allows you to copy a single sheet or multiple worksheets from multiple Excel workbooks. How to merge two Excel files into one by copying sheets If you have just a few Excel files to merge, you can manually […]

By default, Microsoft Excel automatically removes leading zeros from the beginning of numbers. That’s because, from a mathematical point of view, a zero before an actual number is irrelevant. However, there are cases when adding a zero in front of a number is important. Think of postal codes, phone numbers, or account numbers. A lot […]