Found 161 Questions for MS Excel

How to clear table formatting style without losing table data in Excel?

Richa Garg
Updated on 10-Oct-2022 14:20:39
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

How to clear restricted values in cells in Excel?

Richa Garg
Updated on 10-Oct-2022 14:18:26
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

How to clear recent document lists from Excel?

Richa Garg
Updated on 10-Oct-2022 14:13:50
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

How to clear old items in pivot table?

Richa Garg
Updated on 10-Oct-2022 14:10:42
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

How to clear filters when opening, saving or closing workbook in Excel?

Richa Garg
Updated on 10-Oct-2022 14:08:16
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

How to Add Up/Down Bars to a Line Chart in Excel?

Pradeep Kumar
Updated on 29-Sep-2022 12:08:06
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 More

How to Add Plus Sign to Multiple Positive Numbers in Excel?

Pradeep Kumar
Updated on 29-Sep-2022 12:05:03
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 More

How to Add Periods to The End of Cell Contents in Excel?

Pradeep Kumar
Updated on 29-Sep-2022 12:01:42
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 More

How to Add Period After Numbers List in Excel?

Pradeep Kumar
Updated on 29-Sep-2022 11:30:26
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

How to Add Percentage Symbol for Multiple Numbers in Cells in Excel?

Pradeep Kumar
Updated on 29-Sep-2022 10:29:11
When you have to add a Percentage symbol to an existing set of data in Excel, you have two ways to do so. The first one is to select the data and click the Percentage symbol under the Home menu and the other method is to select the cells and format cells for percentage. These two methods will not only add the "%" symbol but also multiply the numbers with 100. This tutorial will help you understand how you can add "%" symbol without changing the value of the numbers. How to Add Percentage Symbol for Multiple Numbers in Excel ... Read More
1 2 3 4 5 6 7 ... 17 Next
Advertisements