Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Dates are stored as numbers in the backend in Excel and can easily be sorted. But what if you want to sort dates by month (irrespective of the year value)? For example, below, I have the birthday dates for some people, and I want to sort and get all the January birthdays together, all the …
It’s not uncommon for many people to protect worksheets in their Excel files and then forget the password. It has happened to me many times, and every now and then, I have people sending me their Excel files asking how to unlock the sheet without the password. The good news is that Excel password protection …
Conditional formatting in Excel allows you to format cells based on the values in the cells. The built-in formatting settings and Conditional Formatting are made to format cells based on the value in the cell itself. But what if you want to apply conditional formatting to a cell based on the value in some other …
Excel is an amazing spreadsheet tool, but there are some things that drive me crazy. One such thing is when you need to copy and paste data into a column with filtered rows. Excel would paste this data into the visible cells as well as the hidden cells that have been filtered out. In most …
When you’re working with the data set that has hidden rows, and you select and copy the cells in this dataset, it is going to copy the visible cells as well as the hidden cells. That’s the default behavior in Excel. But what if you only want to copy the visible cells (and not the …
Excel has the SUMIF and SUMIFS functions that allow you to add a range of cells based on one or more criteria. And sometimes, you may want to get the sum of cells based on partial match in the dataset. For example, suppose I have a dataset as shown below and I want to get …
©trumpexcel.com – Free Online Excel Training
