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
Articles by Shubhi Rastogi
26 articles
How to highlight odd or even numbers in excel?
In the article, the users are going to highlight even and odd numbers present in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the formula for even numbers and odd numbers in the new formatting rule dialog box. The users can use select the range in which they want to fill the color in any cell. Step 1 Deliberate the Excel sheet with the data. First, open the Excel sheet and create the ...
Read MoreHow to highlight rows based on multiple cell values in excel?
In the article, the users are going to highlight the rows based on multiple cell values in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use conditional formatting for highlighting the multiple values in the row. The users can use select the conditional format to highlight the row one by one in which they want to fill the color in any cell. To highlight rows based on multiple cell values in excel Step 1 Deliberate ...
Read MoreHow to highlight the duplicates and overlapping dates in Excel?
In the article, the users will understand how to highlight duplicates and overlapping dates in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the formula for blank cells in the new formatting rule dialog box. The users can use select the range in which they want to fill the color in any cell. To highlight the duplicates and overlapping dates in Excel Step 1 Deliberate the Excel sheet with the data. First, open the ...
Read MoreHow to highlight the last duplicate row/cell in Excel?
In the article, the users are going to highlight the last duplicate row in Microsoft Excel. There are several features in the Excel sheet including Ku-tools, Filter, and Auto Fill tab that the users have to fill any type of color according to their needs. The users can use the formula for counting the numbers in the row. The users can use select the range in which they want to fill the color in any cell. The two examples are depicted in this article, example 1 uses the concept of Filter option and example 2 illustrates the Kutools to highlight ...
Read MoreHow to remove (temporarily hide) conditional formatting when printing in Excel?
In the article, we may go to remove or hide temporary the conditional formatting once the users will print the data they want to print from random numbers in the worksheet that the users have to analyze the data or random numbers to remove the conditional formatting. The users must remove or hide the formatting by using data validation and conditional formatting rules. Incorrect entries, fault is determined by using Data Validation concept. It also reduces the user’s time to find the error resided in the dataset. Example 1: By Using Data Validation Step 1 Deliberate the Excel worksheet. Open ...
Read MoreHow to remove all asterisk characters from cells in Excel?
In the article, the user will understand how to remove all asterisk characters from cells in Excel. The users have to analyze the data or random names to remove the asterisk symbol from all cells either by using the formula or by using the Ku-tools tab. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Remove Characters tab to remove the asterisk characters. After eliminating all asterisk characters, increase readability and clarity of understanding the dataset in MS excel. Ambiguity retains in the database due to asterisk characters will also be eliminated. Example 1: ...
Read MoreHow to remove all dashes from SSN(social security numbers) in Excel?
In the article, we may go to remove or delete all dashes that are created in the cells that we have inserted the data in Microsoft Excel. The users have to analyze the data to remove or delete only dashes in all social security numbers by using the Formula. The users have to delete the dashes by using the Ku-tools tab also. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Remove by Position tab to remove the dashes. Various inbuilt functions are presented in the MS Excel to resolve the complex computational tasks. ...
Read MoreHow to remove all commas in Excel?
In the article, we may go to remove all commas that are created in the cells that we have inserted the data in Microsoft Excel. Excessive use of commas in large dataset create confusion for the users and mistakable calculations to be done if unwanted characters is existed in the excel worksheet. The users must analyze the data to remove or delete only commas in all cells by using the Find and Replace tab. The users have to delete the commas by using the Ku-tools tab also. This method may be completed utilizing a straightforward way within Microsoft Excel by ...
Read MoreHow to remove all characters after the first/last space from cells in Excel?
In the article, we may go to remove or delete all characters after only the first and last space in any sentence which we have inserted in the cells in Microsoft Excel. The users must analyze the data to remove or delete the first or last characters from the left side in all cells either by the formulas or by using the Ku-tools tab also. The steps by step explanations are given in both examples to understand the concept clearly. Users must write the user defined formula correctly to obtain the accurate result. Let’s explore the examples one by one ...
Read MoreHow to remove all dashes/slashes/hyphens from dates in Excel?
In the article, we may go to remove or delete all dashes or slashes or hyphens that are created in the cells that we have inserted the data in a date form in Microsoft Excel. The users must analyze the data to remove or delete dashes or slashes in the date’s row either by using the formula or by using the Format cells dialog box also. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Format Cells to remove the dashes or slashes. In the large dataset, it is very difficult to analyze the ...
Read More