How to hide sheets in Excel [3 methods]
Learn how to hide sheets in Excel using three easy methods: 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 group worksheets in Excel [in easy steps]
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, [...]
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 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 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 [...]
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created 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-2021