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

In this article, we will learn how to remove data restrictions applied on a cell of a worksheet. Many times we encounter an error saying “The value you entered is not valid. A user has restricted values that can be entered into this cell.” This is because, the worksheet designer has applied some data validation in the sheet for specific data values only. We will use two methods to remove the data restrictions from a worksheet as following − Using Data Validation Option under Data Tools Using Paste Special to delete data validation rules Let’s see the steps ... Read More

When we work on multiple excel files, almost all excel application has a feature of keeping last few opened files in history. The list get displayed in Recent Pane whenever we open an excel file to quickly access any of those files without searching into machine. Sometimes we need to clear such long list of workbooks from the Recent pane. This article will help you how to make the recent document lists disappear. We will use the following methods to clear the recent pane − Remove any document from recent pane through right-click Remove the recent pane with Clear ... Read More

In this article we will learn how to update the pivot table data after updating the details of source table. In many cases, whenever we update the source data as per the requirement the old data still appears in the filter of pivot table dropdown options. This may create confusion for the end user who will view the data table and pivot table. To resolve this issue we can use the following steps. Step 1− We have taken a sample data for creating the Pivot Table as following − Step 2− Now, if we update any value in the ... Read More

In this article we will learn to remove filters while opening/closing or saving a worksheet. Because whenever a filter is applied in the worksheet it gets saved along with the file and remain as is until manually removed. They filters may be misinterpreted as missing data in the worksheet. The filters can be removed automatically after applying some Visual Basic codes in the respective worksheet. The following are the VBA codes to be incorporated for this task. Clear filters while opening a workbook Clear filters while saving a workbook Clear filters while closing a workbook Clear filters while ... Read More