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

In general, protection is used in Excel to prevent users from editing it. However, we tend to forget to protect the sheet, but we can automate it by using the VBA application. It will allow you to save the sheet with and without protection. Read this tutorial to learn how you can autoprotect a specific worksheet in Excel. Auto-Protect a Specific Worksheet Here we will insert a VBA code into the whole workbook, and then every sheet will be protected. Let us see a simple process to know how we can auto-protect a specific worksheet in Excel using the vba ... Read More

Have you ever tried to get the values of an object using a drop-down list so that the value represented in the cell is based on the value we select from the drop-down list? This can be done using the process mentioned in this article. Read this tutorial to learn how you can autopopulate other values when selecting values in an Excel drop-down list. Mainly, this process has two parts: the first part is to use the VLOOKUP function, and the next step is creating a drop-down list. Here we will first get the list of marks using the VLOOKUP ... Read More

Let us assume we have a situation where we want to know the date of the last update of a value in a list, and you want to record the date of the last update. This process can be done using the VBA application, as it cannot be completed directly with formulas. Read this tutorial to learn how you can populate date in a cell when its adjusting cell is updated in Excel. AutoPopulate Date in a Cell when its Adjacent Cell is Updated Here we will insert VBA code into the sheet to complete the task. Let us see ... Read More

In Excel, we can get the sequence of numbers by using the auto-fill handle if there are no conditions. But have you ever tried to auto-number the cells by ignoring the blank cells in Excel? This tutorial will help you understand how we can auto-number rows if adjacent cells are not blank in Excel. If you need to manually enter the number, it will be an awfully long and time-consuming process. We can make it a fast process by making it automated. We solve this problem by using the formulas in an uncomplicated process. Autonumber Rows If the Adjacent Cells ... Read More

You could have observed that when we get a list of items by using the filter in tables, if they contain any serial number, they will not adjust, but we can make them in order by using the vba code; this can't be completed using the default operations provided by Excel. Read this tutorial to learn how you can auto-number or renumber after a filter in Excel. AutoNumber or Renumber after Filter Here we will insert a VBA module and then run it to complete our task. Let us see a simple process to understand how we can auto-number or ... Read More

When we try to insert a sequence number into an item in Excel, we always use the autofill handle, but when we try to apply the same process to cells of different sizes, the error appears. This process can’t be completed using the default functions in Excel; instead, we will be using the VBA application to complete our process. Read this tutorial to learn how you can autonumber merged cells in Excel. AutoNumber Merged Cells in Excel Here, we will first insert a VBA module and then run the module to complete our task. Let us see a simple process ... Read More