We can use auto-complete in Excel to tie the elements in the text box to those that are already present in the list. As this process can’t be completed by default, we need to make some changes to the workbook in order to make the autocomplete possible. Read this tutorial ... Read More

Alpha characters include alphabets from "a" to "z" in both small and capital styles. When we try to enter alphabets in Excel, we need to enter each and every letter in the column because we cannot use the autofill handle to do it. When we enter numbers, we can directly ... Read More

Have you ever tried sending an email to the emails in the Excel list? When we want to send a mail to the email address present in the list in Excel, there is no need to open the mail application and enter the email address of each recipient. We can ... Read More

While using the drop-down list in Excel, when we delete data selected from the list, we can see that the top of the list will be left empty. Sometimes this may create a problem, but we can solve this problem by displaying any word instead of an empty cell. ... Read More

When working with a drop-down list that contains many items, it will be difficult to choose just one. This problem can be solved using autocomplete. Read this tutorial to understand how you can autocomplete when typing in an Excel drop-down list. Autocomplete can be used to save a lot of ... Read More

If you've ever tried to insert multiple checkboxes in Excel, you may have encountered difficulty arranging them in a logical order. It will be an irritating process to arrange the checkboxes in Excel, as they are placed very randomly. But using the VBA code, we can auto-centre the checkboxes easily. ... Read More

Sometimes we want to use the same data that is already present in the Excel sheet. Instead of tying data again, we can copy it to other locations. When dealing with large amounts of data, or even small amounts of data, this could save us a lot of time. The ... Read More

When we want to change the size of a specific shape in Excel based on the value present in any cell, we can use VB code to do it. Read this tutorial to learn how you can automatically change the shape and size based on a specified cell value in ... Read More

When we want to add the current date or time in Excel multiple times, it can be a time-consuming process, so we can make it very simple by adding a short cut to finish the process. Read this tutorial to learn how you can use doubleclicking in Excel to automatically ... Read More

When we added the comments to the cells in Excel, you may have noticed that the comment will only contain the name of the user, but we can also customise the comment to add the date and time to the spreadsheet. We can use the process mentioned below to automatically ... Read More