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 by Pradeep Kumar
Page 88 of 104
How to Add Subscript and Superscript to the Excel Ribbon?
Applying subscript and superscript are not default functions in Excel, however you can customize the Excel ribbon or the quick access toolbar to show these functions. In this article, we will take a simple example to demonstrate how you can customize the Excel ribbon. Adding Subscript and Superscript Functions to the Excel Ribbon The Excel ribbon is the place that includes some of the frequently used functions such as Conditional Formatting, Cell Styles, Autosum, etc. Step 1 To display the subscript and superscript functions on this ribbon, right-click on the ribbon and select "Customize the Ribbon", as shown in the ...
Read MoreHow to Add Spaces after Commas in Excel?
We use commas to separate items of the same category in a list. If the words are not separated clearly by commas and spaces, then it looks ugly and impossible to understand. You might have come across situations where you borrowed some data from the Internet and used it in an Excel sheet, only to realize that the data missing spaces and commas. You can, of course, insert commas manually, but it will be a time-consuming affair. In this tutorial, we will show you a simple way to insert spaces after commas in an Excel sheet. Adding Spaces after Commas ...
Read MoreHow to Add Semicolon to Each Cell in Excel?
If you have a huge Excel sheet with lots of data and there is a requirement to add a semicolon to each cell, then you wouldn't surely do it manually. In this tutorial, we will show you a simple hack that you can use for this purpose. Adding Semicolon to Each Cell Using "&" Operator Let's start with the first method. You can add a semicolon to each cell using the "&" operator. Step 1 Let us consider we have the following Excel sheet that contains a list of numbers and names. We will be using the concept of adding ...
Read MoreHow to Add Secondary Axis to a Pivot Chart in Excel?
A pivot cart can help us understand the data in a very efficient manner. In this tutorial, we will show how you can add a secondary axis to a pivot chart in Excel to help depict and comprehend complex data in a simple way. Adding Secondary Axis to a Pivot Chart in Excel Let us assume we have an Excel sheet which contains data similar to the one shown below: Step 1 We need to create a table for the data. To create the table, select the data → click Insert → click table. It will convert our data ...
Read MoreHow to Add Prefix or Suffix into Cell Values in Google Sheets?
Adding prefix or suffix to a set of cell values in Excel is a very-consuming process when we do it manually, however you can complete such a task very easily just by using the simple formula. This article will help you understand how you can add prefix and suffix to cell values. How to Add Prefix into Cell Values? Let see a simple process to add prefix into cell values. Step 1: Let us consider we have an excel sheet where it contains the list of words as shown in below image To add the prefix, use the formula ...
Read MoreHow to Add a Series to a Chart in Excel?
In this tutorial, we will show how you can add an additional series to an existing chart without recreating the chart. This can save you a lot of time and also help you understand the outcome if any new data is added. Using a small trick, we can add a new series to a chart in Excel. Adding a Series to a Chart in Excel Let us suppose we have the following data available in an Excel sheet. To start with, we will convert this available data to a chart. Step 1: To create the chart, select the data ...
Read MoreHow to Add Up/Down Bars to a Line Chart in Excel?
An up/down chart is one of the frequently used charts in Excel to compare the investments and their returns by a company. The creation of the up/down bars to the lines chart in Excel is a complex process, but in this tutorial, we will show how you can do it in a simple manner. How to Add Up/Down Bars to a Line Chart in Excel? Let us see an example to understand how you can add up/down bars to a line chart in Excel. Step 1 First, we need to create a line chart in Excel before adding up down ...
Read MoreHow to Add Plus Sign to Multiple Positive Numbers in Excel?
Generally, we never use a plus sign before an integer (+) to represent that the number is positive. But we always use a minus sing (−) to represent negative numbers, but there will be instances where we want to add the "+" sign before every positive number in Excel. In this tutorial, we will show how you can use the features available in Excel to add a "+" sign automatically to multiple positive numbers in a simple and efficient way. How to Add Plus Sign to Multiple Positive Numbers in Excel Let us take a simple example to show how ...
Read MoreHow to Add Periods to The End of Cell Contents in Excel?
Have you ever thought how you can use the features available in Excel to automatically add a period mark at the end of multiple cells? A Period is nothing but a dot(.) symbol which we use to represent the end of a sentence. Mostly when we write or type any sentence in Excel or Word, we tend to forget the full-stop at the end of the text or even after the end of sentences. In this tutorial, we will show how you can add period marks at the end of cell contents in Excel. How to Add Periods at the ...
Read MoreHow to Add Period After Numbers List in Excel?
A period is nothing but a dot(.) symbol which we can use after each number in the list of numbers. A period is used in Excel to generally represent that a number has ended. Adding a period can be done in two ways in Excel. The first one is by using the formula and the other by using the Format option. Read through this tutorial to find out how you can add period marks after numbers list in Excel in a simple and efficient manner. Adding Period After Numbers List using Formula Let us take a simple example to understand ...
Read More