Mostly, we use header and footer in MS Word, but have you ever tried using the header and footer for work sheets in Excel? This process will divide the infinite Excel sheets into pages and add headers and footers. However, when we apply a header and footer to the first sheet, the same header and footer are added to all the pages in the worksheet, but sometimes you want to add different headers and footers on each process. This tutorial will help you solve this problem, i.e., help you understand how we can apply different headers and footers on each ... Read More

Adding data validation to a single sheet could be a simple matter; we just need to select the cells and click on data validation and enter a formula, but have you ever tried to add data validation to multiple cells at once? Read this tutorial to learn how you can apply data validation to multiple sheets at once in Excel. This process will only allow the data present in the list on the first sheet to be entered in the other cells. The data validation will be applied to the same location where the data is present in ... Read More

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 More

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 More

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 More

We have always formatted the cells in Excel based on the formula that is dependent on its own row or column, but have you ever tried formatting the rows or columns that are dependent on the other row or column? It is possible by making some simple changes to the formula that we will be using for the formatting. This tutorial will help you understand how we can apply conditional formatting to a column based on another column in Excel. The whole process will depend on a formula. Applying Conditional Formatting to a Column Based on Another ... Read More

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

Have you ever tried comparing the data on two different work sheets? Yes, it is possible to compare data from two different sheets in Excel. Let us assume we have two lists that contain the current prices of stocks and the price of a stock last month for a list of stocks, and you want to compare them to know where the price is high. In this tutorial, we will help you understand how you can apply conditional formatting based on VLOOKUP in Excel. Applying Conditional Formatting based on VLOOKUP Here we will apply the conditional formatting to ... Read More

You could have used conditional formatting in Excel very frequently, but have you ever tried applying conditional formatting across different work sheets in Excel? Yes, it is possible to apply conditional formatting across worksheets or workbooks in Excel; it is a very simple process. This tutorial will help you understand how we can apply conditional formatting across worksheets in Excel. Applying Conditional Formatting across Worksheets/Workbooks Here, we will first get the data into one sheet and then apply the conditional formatting to the acquired data. Let's look at a quick way to apply conditional formatting to multiple worksheets ... Read More

You could have added different colours to cells in Excel, but have you tried adding different shades of the same colour to the cells? It is possible to add shades of the same colour to the spreadsheet cells. Adding shades of the same colour will look better than using different colours. This tutorial will help you understand how you can add a colour gradient across multiple cells in Excel by following some simple steps. Applying Colour Gradient Across Multiple Cells in Excel Here, we will first apply the conditional formatting to cells and select gradient colours. Let us ... Read More