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
Microsoft Technologies Articles
Page 113 of 175
How to Apply Shading to Odd or Even Rows/Columns in Excel?
When we are using Excel, we want to add different colours to cells to create a design that can improve the neatness of the data. This also makes the excel sheet look nicer and allows for faster data analysis. This article will help you understand how we can apply colour shading to odd or even rows or columns in Excel. This can be done using a simple method in Excel by using conditional formatting and applying different colours. Read this tutorial to learn how you can apply shading to odd or even rows or columns in Excel. ...
Read MoreHow to Apply Same Formula to Multiple Cells in Excel?
We have tried to apply the same formula to multiple cells in Excel many times. This is the most commonly used process in Excel to get the outputs for multiple cells at once. In Excel, there are several methods for applying the same formula to multiple cells; one method is to select multiple cells while using the formula for formatting and data validation. Then the other way of applying the same formula to multiple cells is to drag the result. Then drag in any direction: up, down, left, right, or any combination of these. Read this tutorial to ...
Read MoreHow to Apply Negative VLOOKUP to Return the Value in Left of the Key Field in Excel?
You could have tried to apply the VLOOkUP function to get the values from the right side using the positive numbers, but have you ever tried to get the values from the left side using the VLOOkUP function using the negative values? When we try to use the VLOOKUP for negative values, an error will occur. To solve this problem, we need to apply the VB code to the Excel sheet. Read this tutorial to learn how you can apply negative VLOOKUP to return the value on the left of the key field in Excel. Apply Negative VLOOKUP to ...
Read MoreHow to Apply Multiple Data Validation in One Cell in an Excel Worksheet?
Applying a single data validation to the cells in Excel is a very simple and frequently used process, but have you ever tried applying multiple data validations to a single cell at the same time? Read this tutorial to learn a simple way to apply multiple data validation rules in one cell in an Excel worksheet. Applying Multiple Data Validation in One Cell We will use a single formula to perform multiple data validations. Let's look at a quick way to apply multiple data validations in one cell in Excel. The problem we solve in this article ...
Read MoreHow to Apply Fuzzy Lookup to Find Approximate Match Result in Excel?
Sometimes in Excel, you want to find the cells with the same data or with approximate data from the existing work sheet. If you try to do that manually, then it will be a very complex and time-consuming process to find them. But we can use a simple function in Excel to complete the work in very little time. Read this tutorial to learn how you can apply fuzzy lookup to find an approximate match result in Excel. We need to use the find function in order to complete the process. You can use the command "CTRL + ...
Read MoreHow to Apply Freeze/Unfreeze Panes to Multiple Excel Worksheets at Once?
Applying freeze is only possible for one row at a time in a column, but have you ever tried to apply freeze or unfreeze panes to multiple worksheets at once? This can only be done using the VBA in Excel. Read this tutorial to learn how you can apply freeze or unfreeze panes to multiple Excel worksheets at once. Applying Freeze Panes to Multiple Excel Worksheets at Once Here we will first insert a VBA module and then run the code to freeze the cells. Let's see a simple process to understand how we can apply freeze panes ...
Read MoreHow to Apply Data Validation to Force Phone Number Format in Excel?
Let us assume we have a situation where we want to allow only numbers for a range of cells in Excel and everyone is entering different data other than a phone number. We can make the cells only allow phone numbers. This process has two steps. The first step is to format the cells as numbers, and the second step is to use the concept of data validation to restrict the data to only being a ten-digit number. Read this tutorial to learn how you can apply data validation to force phone number format in Excel in a simple way. ...
Read MoreHow to Apply Data Validation to Allow Only Numbers in Excel?
Consider the following scenario: you want to allow only numbers in specific Excel cells. Then it can only be possible by using the data validation in Excel. Is it a very simple process? Just use the formula in the type, which will be explained in the below description. Read this tutorial to learn how you can apply data validation to allow only numbers in Excel. Here, we will be considering an empty or new Excel sheet and doing our procedure to apply data validation to allow numbers only in cells from A1 to A10. Applying Data Validation ...
Read MoreHow to Apply Custom Number Format in an Excel Chart?
You have tried applying custom number format in the cells using the format cells, but have you ever tried applying custom number format in an Excel chart? It is a very simple process to apply custom number formatting in an Excel chart; it can be done by formatting the axis. Read this tutorial to learn how to add a custom number format to Excel charts in a straightforward manner. Applying Custom Number Format in an Excel Chart Here we will first create a chart for the given data and then change the scale of the axis. Let us ...
Read MoreHow to Apply Conditional Formatting Search for Multiple Words in Excel?
Assume we have a list of texts where each cell contains multiple words and another list that contains words from the other list, and you want to highlight the cells where these words are present so we can use conditional formatting searches for multiple words to solve the problem in Excel. This tutorial will help you understand how you can apply conditional formatting to a search for multiple words in Excel. Applying Conditional Formatting Search for Multiple Words in Excel Here, we will first name a list and then use the name in the formatting formula. Let us ...
Read More