When we are working with multiple sheets in Excel, we can see that when we open the workbook, it will always start from the sheet where we last saved. This can lead to some privacy issues in Excel. Sometimes you don’t want that to happen, and you want to open a specific worksheet in the workbook. This tutorial will help you understand how we can always start the same worksheet when opening the same workbook. Always Start the Same Worksheet When Opening a Workbook Here we will insert VBA code and then save the code to complete the task. Let ... Read More

When we are using a drop-down list in Excel, the arrow mark of the drop-down list will only appear if we click on any cell of the list. This creates a problem when we are using multiple drop-down lists in a single column. We can solve this problem by adding a persistent arrow mark to the cell in Excel. This tutorial will help you understand how we can show the arrow of a data validation list in Excel. Showing the Arrow of Data Validation List in Excel Here we will first use the data validation list and then inset an ... Read More

You might have used the "Search" or "Find and Replace" functions in Excel many times. It will only search for a current active worksheet, but have you ever tried to apply the search to the whole workbook? This feature can’t be used by default in Excel, but we can make it happen by using the VBA codes in Excel. This process can help you save a lot of time when you are working with multiple worksheets at once. This tutorial will help you understand how we can always search the whole workbook. Always Search in Whole Workbook Here we will ... Read More

When you are collecting the data and presenting it in a chart, it is very important to keep the chart still even when you are moving the data. Generally, in Excel, a chart is saved based on the cells, but we can make the chart float in the sheet even when we scroll the data. This tutorial will help you understand how we can always keep a chart in view when scrolling in Excel. We will be using the concept of VBA code in order to make our result possible. Always Keep a Chart in View When Scrolling Here we ... Read More

If you have ever tried to insert a row in Excel by clicking on the insert button, you can see that the new row will always be inserted below and above the existing cell, but when we want to insert the cell below instead of above, it will not be possible in Excel. This tutorial will explain how to always insert a black row instead of above in Excel using VBA code. Always Insert a Blank Row Below Instead of Above Here we will insert the VBA module and then run it to complete our task. Let's go over a ... Read More

When we get the value of the cell from the cell that is present above the selected cell using some formulas, we know that the data is collected from the address mentioned in the formula, but in this case, if we insert a new row into the cell, then all the addresses of the cells will change automatically. There is also a simple process that does not cause the same problem. This tutorial will help you understand how you can always get the above from the above cell, even when we delete or insert a row in the Excel sheet. ... Read More

Have you ever wondered if Excel has a feature that can notify you of approaching deadlines? It will assist us in understanding the importance of each task and the sequence in which they must be completed in order to be submitted on or before the deadline. This tutorial will help you understand how you can alter the approaching due date in Excel. Altering an About Approaching Due Date/Deadline in Excel Here we will use the "IF" formula to get the first result, then use the auto-fill handle to complete our task. Let's see a simple process in Excel that helps ... Read More

When we want to perform sorting and filtering in the locked cells in protected sheets, it will not be possible because the protected sheets, which are created with default settings, can’t be able to do so. But if we follow the below-mentioned process, we will be able to allow sorting and filtering even for locked cells in protected sheets. In this tutorial, we will learn about how we can allow sorting and filtering of locked cells in protected sheets. Allowing Sorting and Filtering of Locked Cells in Protected Sheets Here we will first create a table, then protect the sheet ... Read More

Sometimes we have a column where we want the user to enter only yes or no for the whole column. The people are entering things like "maybe" or any other words in the "Yes or No" column, and if you want to restrict the user to entering Yes or No, then we can use this simple trick in order to generate an error message if any other words are entered other than Yes or No. In this tutorial, we will learn how we can allow only yes or no entries in Excel. Allowing Only Yes or No Entry in Excel ... Read More

Assume we want to create an excel that contains information about the dates of some important events, and everyone is attempting to enter data other than dates in the column, and you want to restrict them to only entering the date in the specified column. We can make that happen using some Excel tricks. In this tutorial, let's see a simple trick where we only allow date format data in a specified cell. Here we will add the data validation to allow only dates. Let us look at a simple example to see how we can limit the date format ... Read More