Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
There isn’t any trickery involved in this post. I just want to give you a quick and simple way to insert new cells in excel. First, let’s see the usual way of doing it. Suppose, you have a data set as shown below and you want to insert blank cells in C2:C4, in such a …
One of my colleagues asked me if it is possible to make multiple selections in a drop-down list in Excel. When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection. He wanted to make multiple selections from the same drop …
Today I am going to give you a powerful formula cocktail. The less-used INDIRECT() and ROW()Â function together with the MID() function can create a magnificent concoction. This triad enables you to get into the contents in a cell. and analyze each character separately. For example, suppose you have Excel123 in a cell, and you want …
A lot of my colleagues spend a lot of their time in creating a Summary Worksheet in Excel. A typical summary worksheet has the names of all the worksheets in different cells and all the names also hyperlinked to these worksheets. So you can click on a cell with a sheet name (say Jan, Feb, …
We all use Google as a part of our daily routine. One of its features is search suggestion, where Google acts smart and gives us a list of suggestions while we are typing. In this tutorial, you’ll learn how to create a searchable drop-down list in Excel – i.e., a drop-down list that will show the matching …
Below is the complete written tutorial, in case you prefer reading over watching a video. Conditional Formatting in Excel can be a great ally in while working with spreadsheets. A trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set. And it is as …
You can insert a lot of interactive controls in an Excel worksheet using the Excel developer tab. These interactive controls (such as a check box, radio button, combo box, scroll bars) are quite useful when you are creating interactive workbooks or excel dashboards. But there is a possibility that you may not have the Developer …
Input Message in Excel can be used to show a message when a cell is selected. It is particularly useful if you want to show some instructions to the user when he/she selects a cell. Examples could be to display form filling instructions or data entry instructions. Can’t this also be done using comments in …
In this tutorial, you’ll learn how to find the position of the last occurrence of a character in a string in Excel. A few days ago, a colleague came up with this problem. He had a list of URLs as shown below, and he needed to extract all the characters after the last forward slash (“/”). …
©trumpexcel.com – Free Online Excel Training
