How to remove last character in Excel
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 [...]
How to wrap text in Excel [step by step]
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 [...]
How to lock cells in Excel and protect formulas [easy guide]
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 [...]
How to hide sheets in Excel [3 methods]
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 [...]
How to indent in Excel [multiple solutions + keyboard shortcut]
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 [...]
How to unmerge cells in Excel
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 [...]
How to clear formatting in Excel [multiple options + keyboard shortcut]
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 [...]
How to add a whole column in Excel
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 [...]
How to create barcode in Excel
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 [...]
How do I know what version of Excel I have installed?
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 to merge Excel files into one
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 [...]
How to add zero in front of number in Excel [9 methods]
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, [...]
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>