It is not very frequently that we are required to manipulate photographs or images within Excel, yet, judging by the volume of Google searches for this issue, it is evident that people are interested in learning more about how to do so. When you try to insert an image in Excel, you may have noticed that the image will not align with the cells in Excel. This tutorial will help you understand how we can automatically change all pictures to move and resize within cells in Excel. Automatically Change All Pictures to Move and Size with Cells Here, we will ... Read More

Let us assume we have a situation where we want to insert a row below or above a specified value. This process can’t be done by default in Excel, so we will be using the help of the VBA application to complete our process. Read this tutorial to learn how you can autoinsert rows in Excel based on cell values. If we try to complete this task manually, it can be a time-consuming process, as inserting a new row is a multi-step process. AutoInsert Rows in Excel Based on Cell Values Here we will first insert a VBA module and ... Read More

Let us assume we have an Excel sheet that needs to be printed multiple times, and you want to know how many times the sheet is printed. There is no way in which we can solve this in Excel, but this can be solved using the VBA application. Read this tutorial to learn how you can automatically increment cell values in Excel after each printing. Auto-Increment Cell Value after Each Printing Here we will first insert a VBA module and then run it to complete its task. Let us see a simple process to understand how we can increment cell ... Read More

When we have a large amount of data on a single visible sheet, we can have the problem of straining our eyes to see the selected value clearly, which leads to a value misreading. But we can solve this problem by highlighting the row and column of active cells with different colours. This tutorial will help you understand how we can automatically highlight rows and columns of active cells in Excel. Auto-Highlight Row and Column of an Active Cell Here we will insert VBA code for the sheet, and then every time we select a cell, the row and column ... Read More

Sometimes, when we delete data from multiple columns in Excel, we even need to delete the empty columns. But in Excel, deletion of multiple columns at once isn’t possible, and deleting columns individually can take a lot of time. We can solve this problem by hiding the empty columns in Excel. Read this tutorial to learn how you can automatically hide columns if there are blank cells in a column. AutoHide Columns if There are Blank Cells Here we will first insert VBA code for the sheet, then double-click on any cell to complete our task. Let us see ... Read More

We can see that if we try to fit a large amount of data into one cell, the data will now be displayed if we move to another cell; the only way to solve this problem is to increase the row height of the cell. For only one cell, we can adjust the height of the row by using the command "Alt + Enter", but when we try to merge the cells of different heights, we can face the same problem; we can’t use the command. Read this tutorial to learn how you can solve this problem, i.e., how to autofit the ... Read More

Adjusting the width of each column in Excel is one of the most frequently used processes. When we use formats like date, we can see that the width of the cell is automatically fitted, but this does not always happen. When the width of the cells is not enough to display the data, then a series of "#" symbols will be displayed in the cell. This problem can be solved using the auto-fit function. Read this tutorial to learn how you can autofit column width in Excel. AutoFit Column Width in Excel Here, we'll use three simple shortcuts to complete our ... Read More

Generally, in Excel, we can always apply a filter to a list just by using a slicer, and we can click on the cell value you want to filter internally. But if you want to apply the filter based on a cell that is not inside the table, we cannot do it with the help of Slicer. We can complete this process with the help of the VBA application. We can apply the filter using an external value. This tutorial will help you understand how you can auto-filter rows based on a cell value in Excel. Step 1 Here we ... Read More

When you want to create a list of dates that only include weekdays in Excel, you can do it by default by using the formulas supported by Excel. For example, if we want to create a list of working dates in an office, we can use this process. Leaving out the weekends means ignoring the dates of both Sunday and Saturday in the list. This tutorial will help you understand how you can autofill weekdays and exclude weekends in a list of Google Sheets. We can complete this process just by using a single formula. We can complete this process ... Read More

When we insert a new row in the table of data where we have the formula in any of the columns, you can see that the formula will not be applied to the new row even though we entered the data in the cell. We need to reapply the formula with the auto-fill handle to all the cells manually. If you are dealing with frequently changing data, you may end up wasting a lot of time applying the formula. You can solve this problem by enabling the formula to auto-fill when inserting new rows in Excel. This process can be ... Read More