Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to add header or footer to first page only in an Excel worksheet?
If you add a header or footer to a worksheet, generally, all pages within the worksheet will have the same header or footer. However, sometimes you need to add the header or footer to the first page only. The ability to add headers or footers to a printed worksheet in Excel allows you to place them at the top or bottom of the worksheet. Adding a Header or Footer to the First Page of a Worksheet In order to insert headers or footers onto the first page of a worksheet, you can follow the steps given below − Step 1 ...
Read MoreHow to add horizontal benchmark/target/base line in an Excel chart?
It is possible to finish the challenge by plotting two distinct kinds of data points on the same graph. Let's imagine you've made a column chart in Excel to display the quantity of sales made by four different teams. But now you want to include a horizontal benchmark line in the chart; how do you think you should go about doing that? This post will provide three potential options for you to consider. Draw Horizontal Benchmark/Target/Base Line You are keeping track of students' grades using a simple Excel spreadsheet. you need to add a horizontal baseline to this chart ...
Read MoreHow to add hyperlink to comment in Excel?
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 MoreHow to add image as background into chart in Excel?
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 MoreHow to add leader lines to a chart in Excel?
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 MoreHow to add leading zero to fixed number length in Excel?
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 MoreHow to add minor gridlines in an Excel chart?
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 MoreHow to add mouse over tip to a certain shape in Excel?
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 MoreHow to add moving average line in an Excel chart?
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 MoreHow to add multiple fields into a pivot table in Excel?
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