Microsoft Technologies Articles - Page 112 of 175

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 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

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 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

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 color-banded 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 a simple process to apply color-banded rows or columns in Excel. Applying Colour Banded Rows or Columns Using Conditional Formatting ... Read More

We could have created many types of charts in Excel and customised them to get our output, but the customization of charts could be a time-consuming process. If there is any type of chart that we will be using more frequently and which is not the default type in Excel, we can save the template of it in order to access it very quickly. We can save a template by selecting the existing chart and right-clicking and selecting "Save as template" from the menu box. Read this tutorial to learn how you can apply a template to an ... Read More

Have you ever tried to access the data in two workbooks at once? You could have compared data in two sheets of the same workbook using the VLOOKUP function. We can also connect the two worksheets in Excel. This process can’t be completed using the formulas; we will need to use the VBA code. This tutorial will help you understand how we can apply a button to open another workbook in Excel. Applying a Button to Open Another Workbook in Excel Here we will first insert a shape and then assign a macro to it. Let us see ... Read More