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

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

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

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

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

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

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

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

When just starting out people often find themselves wondering how to add a whole column in Excel. Usually, a formula only applies to a range of cells, not the entire column. This is actually really simple to achieve and I will show you two quick methods on how to do it: one with a formula, […]

This is a step-by-step guide on how to create a barcode in Excel. Generating barcodes takes only a few steps, but you will need to download and install a free barcode font. The alternative would be to use Excel barcode add-ins. You can download the Excel spreadsheet I’ve used when making this tutorial. How to […]

Whenever you need to troubleshoot Excel issues, the first thing you should do is check whether you have the latest version available. A question I get asked a lot is, “How do I know what version of Excel I have installed?” In the following article, I will try to help you find the version of […]

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