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

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