Have you ever thought that we can send an email from an Excel formula with a single mouse click? When you click on a mailto hyperlink in Excel, an email message will be generated automatically with the fields that you choose spelled out. This happens automatically. However, when you send an email from Excel using the mailto hyperlink function, there is just one line in the actual email body. In this tutorial, we will demonstrate how to insert a new line into the body of an email when using a mailto hyperlink in Excel. The goal is to include a ... Read More

When building a pivot table, we must manually drag each field into the Row Labels or Values. The remaining fields ought to be added to the Value box if we have a lengthy list of fields, though we may easily add a few row labels if we do. Adding multiple fields into pivot table will be useful when we want look after the pivot table with multiple dimensions and facts. Step 1 At first, we must create a sample data for creating pivot table as shown in the below screenshot. Step 2 Now, select the data range from A1:J19. ... Read More

It may be difficult to determine the direction in which the data is trending when looking at a chart that has just been made in Excel. These visualisations can have thousands upon thousands of individual data points. In some cases, we can determine the direction in which the data is moving over time; however, in other cases, we must use various tools within Excel to figure out what is going on. The use of trend lines and moving average lines will help you achieve this goal The use of trend lines is becoming increasingly commonplace when trying to determine the ... Read More

ScreenTips are little windows that appear when the pointer is over a shape and displays descriptive text. ScreenTips can be used to display additional information for a shape. Add Mouse Over Tip to a Certain Shape with Adding Hyperlink With ScreenTip, you can add a link to a certain shape in a worksheet. Let’s understand step by step with an example. Step 1 First, click insert > illustration, then select shape option. Step 2 Select the shape that you want to add a ScreenTip to. Step 3 Once you select the shape, it will ... Read More

In most cases, the horizontal gridlines that should be included in a column chart, bar chart, or line chart will be inserted automatically. However, there are situations when you would wish to reduce the spacing between the gridlines, as illustrated in the picture below; how can you do this? Excel makes it possible to include additional minor gridlines in a column, bar, or line chart. Step 1 You are going to learn how to add minor gridlines to a line graph by looking at this little example. In order to get it done, Step 2 Choose the data from ... Read More

You have a list of numbers with varying character lengths, and it seems cluttered and disorganised. You may add a leading zero to any fixed numbers that have the same length as the screenshot shown below to make the display more organised and clearer. Using TEXT Function You will be able to add a custom formatting to any numerical data that is already present in your spreadsheet by using the TEXT function. = TEXT ( Value, Format) This is the value that you wish to convert to text and add formatting to once it has ... Read More

You can use the features available in Excel to include leader lines in the Chart Series Labels of Column Charts, Line Charts, Bar Charts, Area Charts, XY Scatter Charts, and Pie Charts, which are among the most often used chart types. In fact, you do not have to do anything out of the ordinary in order to get the leader lines; they will appear on your chart automatically when you add Data Labels to it. You may locate a leader line by just dragging and dropping a label onto your chart. Once you do this, you will see that the ... Read More

You can easily recognise a data series in a chart by adding data labels to the data points of the chart. This will help you to identify the data series more quickly. The data labels on the worksheet are connected to the values by default, and when these values are modified, the links between the labels and the values are immediately updated. Let’s understand step by step with an example. Step 1 In our example, we have student’s name, Marks in an excel sheet in columnar format. Refer to the below screenshot. Step 2 Create the Bubble Chart − ... Read More

In order to make the data more understandable, we need to include charts in the majority of the Excel files. In addition, we can either put a photo as the backdrop of the chart or fill the chart background with colour to make it more obvious. This tutorial will provide you with an in-depth breakdown of how to put the aforementioned features into action, along with detailed instructions and images. If you follow all of the procedures, you will ultimately be able to fill up the chart backdrop with the appropriate colour or image. Step 1 Fill in the ... Read More

Excel allows you to include hyperlinks in cells that will take you directly to that URL. Sometimes, you may want to include a URL in the comment, but the hyperlink address you write in the comment cannot be clicked. Now I'll show you how to create a hyperlink that can be clicked in an excel comment. There are many different ways to create hyperlinks in Excel − Manually type the URL (or copy paste). Using the HYPERLINK function. Using the Insert Hyperlink dialog box. Add Hyperlink to comment. But, in this article we are discussing about ... Read More