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
Articles by Pradeep Kumar
Page 88 of 104
How to Add or Remove Strikethrough in Excel?
Generally, strikethrough is used in Excel to represent that the data present in the cell is an error or the event is completed. Strikethrough is also used to represent that the event or the process has successfully completed without any error and mistakes. In this tutorial, we will show you a simple process to add or remove strikethrough in Excel. How to Add Strikethrough in Excel? Let us see a simple process to see how to add strikethrough in Excel. Step 1 We will use the following data and add strikethrough in a selected few cells. To add ...
Read MoreHow to Add Vertical/Average Line to Bar Chart in Excel?
We can add a vertical/average line to a bar chart in Excel by using the horizontal bar graph. The average line is used to analyse the data value in the graph but checking whether we have reached the average or not in the particular interval. Adding vertical average line to a bar chart in Excel is a simple but lengthy process. In this tutorial, we will show you the step-by-step process to add a vertical/average line to bar chart in Excel. Step 1 First, we need to create a horizontal bar chart. Select the data and then click "Insert". Then ...
Read MoreHow to alternate row colour in an Excel Pivot Table?
Displaying alternate row colours in a normal table is a very simple process which can be done using the conditional formatting concept but creating alternate row colour in pivot table is simple problem. A pivot table in Excel is an interactive table which helps in quickly summarizing the data. When we want to add alternate row colour in a pivot table is a lengthy and simple problem.so let us see a simple trick to end this problem. Let us see a simple process to add alternate row colours in an Excel pivot table. Step 1 Let us consider the table ...
Read MoreHow to Alternate Row Colour Based on Group in Excel?\\n
As we all know that we can change the colour of alternate rows with different colours very easy in excel but have you ever wondered can alternate row colour based on the condition the condition can be anything. We will try to choose the colour for the row based on a single condition. We can achieve this by just following this simple process to alternate row colour based on group in excel Let us see a simple process to alternate row colour in Excel based on group. Step 1 Let us assume a situation where we have a data where ...
Read MoreHow to align duplicates or matching values in two columns in Excel?\\n
Let us assume we have a situation where we have collected names of people from two sources and you want to know the names of the people who have registered from the both sources and we want to make a list of then them so we can use this simple process to list the names of people present in both lists. We can also find the duplicate names present in the both lists. Let us see a simple process to align duplicate or matching values in two columns in Excel. Step 1 Open an Excel sheet where there are two ...
Read MoreHow to Add Percentage of Grand Total/Subtotal Column in an Excel Pivot Table?
When we create a pivot table in excel where there is a list of items and you want to know their share in the list in percentage. Read through this tutorial to understand how you can create a new column where it shows the percentage of grand total or subtotal column in a excel pivot table in a simple process. How to Add Percentage of Grand Total Column in Excel Pivot Table Let us see a simple process to add percentage column of total column in an Excel pivot table − Step 1 Let us assume the Excel sheet where ...
Read MoreAverage Data in Multiple Non-Contiguous Ranges in Excel
The AVERAGE function determines the average value of the numbers that are passed to it in the argument list. Excel first totals all of the numerical values, then divides that total by the number of numerical values to arrive at the average. The AVERAGE function accepts several arguments, up to a maximum of 255 in total, in the pattern num1, num2, num3, and so on. Arguments can be anything from constants and arrays to ranges and cell references. They can even be numbers. There is no processing done on cells that are either empty or contain text or logical values. ...
Read MoreHow to delete rows above active cell or specific text in Excel
There are several ways that an Excel user can delete rows if a cell contains a specific text, as explained in this article. At times, when you work with large data sets, you might find that you have to delete rows based on the values of the cells or based on conditions found within the data set. Filter Rows based on Value/Condition and then Delete them One of the best ways to delete rows that contain a specific value or fulfill a given condition is to filter these. Once you have the filtered data, you can delete all these rows ...
Read MoreSimple ways to quickly remove multiple blank or empty rows in Excel
You are going to experience a great deal of frustration if there are hundreds of blank rows that need to be eliminated from the entire worksheet or workbook. In the following section of this article, you will find a listing of some efficient ways that will handle this job for you step by step. Remove Multiple Blank Rows in Excel with the Go To Special Command Now, kindly follow the steps below to remove rows that are empty and replace them with "Go To Special" rows. Let’s understand step by step with an example. Step 1 In our example, we ...
Read MoreHow to quickly jump to the adjacent cell based on the selection in an Excel dropdown list?
The typical user of Microsoft Excel can benefit from the use of a dropdown list in order to simplify the data entry process. When entering data into a selected cell, using a drop-down to restrict entry options expedites the process and reduces the likelihood of making errors. Using the Data Validation feature of Excel, which will be covered in this post, you may quickly and easily generate a drop-down list of options. You can construct a drop down list in Excel by naming a list of things that is based on an Excel table that has a specific name. After ...
Read More