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
MS Excel Articles
Page 105 of 119
How to Add Spaces between Numbers in Excel?
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 MoreHow 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 clear table formatting style without losing table data in Excel?
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 MoreHow to clear restricted values in cells in Excel?
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 MoreHow to clear recent document lists from Excel?
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