When you collect data from another source and use that in an Excel sheet, it may not look good. The space provided between numbers in an Excel cell is very less and it will not be very clear. There is a need for increasing the space between the numbers in the cell to represent the numbers neatly. You can use Formulas in Excel to add more space between numbers. In this tutorial, we will take an example to show how you can use a simple formula to add space between numbers in cells and make them more presentable. Adding Spaces ... Read More

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 More

A series line in Excel helps us to connect the data objects of same time period. A series line helps us to analyse the charts more efficiently without any confusion. A series line connects the data objects of same rows with a line. Generally, series lines are added to the stacked or 100 stacked columns. In this tutorial, we will demonstrate how you can add series lines in a chart in Excel. Adding Series Line in an Excel Chart Let us suppose we have an Excel sheet with the following data: Step 1 To create the chart, select the ... Read More

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 More

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 More

Have you ever wondered how you can add quotes to the text or words in Excel? Adding quotes is similar to adding symbols as prefix and suffix to the words. It can be done using the "format" function in Excel. In this tutorial, we have provided a detailed step-by-step explanation of how you can add quotes around numbers or text in Excel. Adding Quotes around Text using "Format Cells" Option You can use the "Format Cells" option in Excel to add quotes around numbers or text. It is simple process. Step 1: Let us suppose we have an Excel sheet ... Read More

You might have come across situations where you need to add common words at the end or beginning of a range of cells in Excel. It can be a time-consuming process if you decide to do it manually. In such cases, you can use the concept of suffix and prefix in order to complete the process very easily. Read through this article to find out how you can add prefix or suffix to a range of cells in Excel in an efficient manner. How to Add Prefix to a Range of Cells? Let us see a simple process to add ... Read More

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 More

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 More

In this article, we will learn how to remove the table formatting in an excel file without losing the data. Sometimes the table formatting may hide some parameters based on some conditions and that may get lost while copy-pasting the data from one sheet to another. Let’s have a look on the steps to clear table formatting. The formatting of a table can be removed using the following options − By using Convert to Range under Table Tools By using Clear Table Design under Table Design By using Clear Formats under Editing Convert to Range feature This feature ... Read More