Found 2044 Articles for Microsoft Technologies

A drop-down list is used to choose a single item from the list of data. When we add an item to the source data, we can see that the list will not be updated. A drop-down list is used to select an item from many items, but if we try to add an item to the list, we need to create a new list again. However, there is a way in Excel to auto-update drop-down lists when new data is added to the sheet. This tutorial will help you understand how we can auto-update drop-down lists in Excel. Auto-Update a ... Read More

When we have an existing chart and you need to add new data or update the existing data, this can be done by manually updating the chart, but it can be a time-consuming process. In this tutorial, I will explain the method that saves you time. This tutorial will help you understand how we can automatically update a chart after entering new data in Excel. This can be done in two ways: first, by using the tables, and second, by using the dynamic formula. Auto-Update a Chart after Entering New Data Using Tables Here we will convert our data into ... Read More

When we are performing a sum for a single column or row in Excel, we can directly use the formula to do it, but if we are doing the same process for multiple rows or columns at once, we cannot do it using the formulas. We can complete the process by using the auto function in Excel. This tutorial will help you understand how we can autosum multiple rows, columns, or worksheets in Excel. AutoSum Multiple Rows in Excel Here we will use the autosum function under formulas. Let us see a straightforward process to see how we can autosum ... Read More

Strikethrough is a type of data used in Excel to indicate that the data present in the cell is an error or that the event has been completed. The strikethrough is also used to represent that the event or process has successfully completed without any errors or mistakes. Strikethrough is not a default font that we can use directly in Excel, but we can use it by applying an uncomplicated process. We can also add the strikethrough to the cells based on the cell value using conditional formatting. For example, we can add the strikethrough to cells with values greater ... Read More

When we have a list of dates in an Excel sheet and you want to sort them, we cannot do it using the general method. We can use this special method used in the article to do it. If the dates in the list are sorted, it will help us to analyse our data very clearly. This tutorial will help you understand how you can automatically start the date when a date is entered or changed in Excel. The dates that are newly inserted and updated will also be sorted directly. This can save you a lot of time in ... Read More

We can sort a list of texts in Google Sheets manually, but it will be a very time-consuming process. Instead, we can use a simple process to do it automatically in Excel. We will be using a direct button present on the data menu in the Excel ribbon. Sorting is nothing more than arranging the data in an ascending or descending order based on a single column. We will be sorting the data in ascending order in the below process. This tutorial will help you automatically sort data alphabetically in Google Sheets. We can sort any kind of data by ... Read More

When we are working with the data related to numerals, it is very important that we always sort the data in order to analyse it better. Sorting can be done in either ascending or descending order. Sorting can help us compare the values and their importance on the sheet. Generally, in Excel, we will sort the data by using the sort function, but if we insert or update a new value in the list, then we need to do the process again. Read this tutorial to learn how you can autosort columns by value in Excel. AutoSort Columns by Value ... Read More

Have you ever wondered if there is any way in Excel to automatically size the comment box to fit its contents? This is only possible using the VBA application. Using VBA code, we can customise the sheet to automatically fit the size of the comment box to its contents in Excel. This tutorial will help you understand how we can automatically size comment boxes to fit their content in Excel. Auto-Size a Comment Box to Fit Its Content in Excel Here, we will first create a VBA module and then run it to complete our task. Let us see a ... Read More

When we are dealing with text boxes, it is very important to update and delete the data inside them, but if it contains a large amount of data, we need to select the data inside the text box and delete it. In this tutorial, I will explain the process for selecting the data in a text box by clicking on it. This tutorial will help you understand how you can autoselect text from a textbox when it is selected in Excel. Auto-Select the Text of a Textbox When It is Selected Here, we will first create a macro and then ... Read More

When we enter some data in Excel, we need to save the sheet to access the data even if we close it. When we have an Excel sheet with frequently changing data, we must save the sheet each time. When we were changing the data frequently, this wasted a lot of time. This tutorial will explain how we can save an Excel file automatically after entering data. We will be using the help of the VBA application to complete the process, as this can't be completed directly in Excel. Autosave an Excel File after Entering Data Here we will insert ... Read More