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 111 of 119
Add text and number into specified position of cell in Excel
There may be times when you need to insert the identical text into all of the cells that are contained inside a column. It's possible that a specific title needs to go before the names in a list, or that a specific symbol needs to go at the end of the text in each cell. Both of these things need to be done. The task of adding text or numbers to cells in Excel is one of the most often performed tasks. Including things like inserting spaces between names, including prefixes and suffixes in cells, and inserting dashes in social ...
Read MoreChange chart colour based on the value in Excel
Conditional formatting refers to the process by which you can show distinct value ranges as different colours in a chart. This may be something you wish to do when you insert a chart at times. Because the Excel feature only applies to cells and not charts, we can apply the concept of conditional formatting to column charts by combining different data series. This is because conditional formatting is only applicable to cells. For instance, if the value range is 0–150, the series colour should be shown as blue. If the value range is 151–250, the colour should be shown ...
Read MoreChange the font / size of row and column headings in Excel
When you use the Excel workbook, have you ever tried to alternate the font or measurement of row and column headings to make the headings larger or extra beautiful? In fact, Excel offers some tricks for you to solve this task. With the futures we have in the Excel workbook, you can change the font and size of the row and column as you like. Change the Font and Size of Row and Column using the Styles Feature in Excel Following are the steps to change the Font/Size and row/column in excel. Step 1 Open the workbook that you want ...
Read MoreCombine the COUNTIF and LEFT functions to count cells that begin with a certain character in Excel
Excel's COUNTIF function is used to determine the number of cells inside a given range that fulfil the requirements of a certain condition. In the criteria, logical operators such as ">,
Read MoreCompare two columns and add missing values in Excel
We all occasionally find ourselves in the position of having to compare columns in Excel. When it comes to comparing and matching data, Microsoft Excel has a lot of alternatives; however, the majority of these options center on searching in a single column. When you have data organized in two distinct columns, you may need to compare them in order to determine which column is lacking certain information and which column contains information that is already there. Depending on what you hope to achieve from making comparisons, you can approach the task in a number of different ways. Let’s learn ...
Read MoreCompare two columns for matches and differences in Excel
The task of comparing columns in Excel is one that will eventually be required of each and every one of us. When comparing and matching data in Microsoft Excel, you may do so in a variety of ways; however, the vast majority of these approaches focus on searching within a single column. When you compare and match data in Microsoft Excel, you can do so in a variety of ways. Comparing the data in two columns in a large Excel spreadsheet can be a time-consuming process when working with such a document. You can save time by using Excel's ...
Read MoreConditional formatting rows or cells if two columns equal in Excel
When comparing and matching data in Microsoft Excel, you may do so in a variety of ways; however, the vast majority of these approaches focus on searching within a single column. When you compare and match data in Microsoft Excel, you can do so in a variety of ways. Instead of receiving the result in a separate column, which is something you may do if you want to highlight certain rows, conditional formatting enables you to highlight the rows that contain matching data. This can be done in place of getting the result in a separate column. In this ...
Read MoreConditional formatting stacked bar chart in Excel
When working with charts, there will be instances when you wish to emphasise objects in a certain way depending on whether they are positive or negative, or if they are above or below a benchmark or an average. Even while conditional formatting may be applied to cells, it is not as simple to apply the same style to a bar chart as it is to individual cells. There is no easy way to accomplish this that does not involve some sort of manual labour. On the other hand, the best part is that there is a way around this problem. ...
Read MoreExcel Tutorial – How to Combine Columns, Rows, and Cells?
There are many different scenarios in which you might use Excel to integrate information. At other times, it's to make the formatting look better. At other times, it serves the purpose of bringing information from a number of cells into a single cell. Excel presents us with a number of opportunities to deal with textual data. It may be a name, an address, an email address, or any number of other possible text sequences. Excel users will frequently find themselves in a situation where they need to merge adjacent cells that contain text data. Merge Cells for Excel ...
Read MoreHow to add a border to cells by using IF statement in Excel
To add a border around the cells is easy and handy for most Excel users, however how about including a border to cells with the aid of the usage of the IF function. In this article, you will learn how to add a border to cells via an IF statement in Excel. Add a Border to Cell Using the IF Statement To add a border to cells through the IF statement, you can observe the effective Conditional formatting feature, and then add the IF statement to its rule Step 1 For example, consider you have a range of ...
Read More