Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Recently, I was working on a project where I had data in multiple rows, and I needed to combine the multiple rows and get the result in one single column. There are multiple ways to do this in Excel. If you’re using Excel with Microsoft 365, there is a dedicated formula to do this, and …
Excel worksheets are made up of cells with default heights and widths. In most cases, you will need to adjust the cells to adjust your dataset. In this article, I will show different methods you can use to make the cells bigger. Zoom-in The Worksheet One quick way to make the cells appear bigger is …
In this article, I will show you how to convert days to months in Excel using a couple of simple formulas. This could be useful when you are creating a project plan that has a start and an end date, and you want to know how many months there are between the start and the …
It’s easy to add sheet names to header or footer in Excel. Once done, the sheet name will appear In the header or the footer of the page when you print it. This is especially useful when you’re working with a large workbook and need to print multiple worksheets. Having the sheet name in the …
If your Excel application is crashing or causing issues, you can try opening it in the ‘Safe Mode’. When you open Excel in safe mode, it disables features such as add-ins and custom settings, which helps you troubleshoot and identify the issues. In this quick guide, I will show you two easy ways to open …
Need to find out which version of Microsoft Excel you have? It’s pretty easy to do and only takes a few clicks. Whether you’re fixing an issue, installing an add-on, or just curious, it’s good to know your Excel version. Knowing your Excel version also helps when you’re working with other people who have different …
One formatting option you can use when you want to highlight a specific text or cell is the underline option. As the name suggests, it applies an underline below some text in a cell or the entire cell. In this article, I will cover the different types of underlines in Excel (single, double, single accounting, …
Removing duplicates is a common task for most data workers. While in most cases, you would be working on removing duplicates from a range of cells, sometimes, you may need to remove duplicates from a cell. For example, below, I have a dataset with duplicate values in each cell and I want to remove the …
Remove asterisk (*) symbol In Excel is a little tricky as it’s a wildcard character and you cannot just use fine and replace to remove an ace risk symbol. But nothing to worry about – I’ll tell you a simple methods to quickly remove all the asterisk symbols from your data set using the Find …
©trumpexcel.com – Free Online Excel Training
