Excel Unlocked

19 Everyday Use Excel VBA Codes

While working with excel, there are many excel tasks that you cannot perform using inbuilt Excel features and functions. Or accomplishing those tasks using Excel inbuilt features and functions may be a time-consuming and boring job. Surprisingly, Excel VBA Code can help you. In this blog, In this blog, I would like to share 19 of those most useful and everyday used excel VBA Codes that can make your excel task quick and easy.

Do you Need Excel VBA Codes Knowledge?

Answer is to this is – No 😎

Table of Contents

Do you Need Excel VBA Codes Knowledge?

8 Errors in Formula in Excel and How to Resolve

Errors in excel formulas are inevitable. No matter how expert you are, some or the other day, you might have come across excel formula errors. …

“Arrow Keys Not Working in Excel” – Solved

If you want to move your active excel cell from one cell to another, you probably have three different ways. You may directly click on the cell using your mouse, or you may navigate using the keyboard arrow keys, and many more. However, the best and the most comfortable way is to use the keyboard arrow keys. Do you agree with this? I am sure, your answer is – YES 😎 However, sometimes while you are using the arrow keys it does not move from one cell to another cell. Instead of taking you to one cell right or left, the entire worksheet area moves. In this blog, we would unlock the answer to this question – ‘Why the arrow keys are not working in my excel?“

The reason for this is that you have mistakenly turned on or enable the Scroll Lock in Excel. So the solution is now quite simple. You need to disable or turn off the scroll lock in excel, and your problem is solved.

Learn Excel Keyboard Shortcut in Infographic

Who does not like to be quick when it comes to using technology!! No matter how much you know excel functions and tools, but I …

Multiple Ways to Reduce Excel File Size

Many a time, excel user ask me this question that “Hey Dhrunil! How to Reduce and Compress Excel File Size?“. My simple answer to this question is – Clean your excel data and Remove unwanted stuff from your excel file, and you are done. In this blog, we would go through some of the well-tested possible solutions to the question – “Why my excel file takes too long to open?“

ExcelUnlocked – Mouse and Keyboard Combo Tricks

In our previous special Excel Unlocked blog, we had gone through some of the mouse double click tricks that everybody should know. It helps to save a lot of your time and reduces some unwanted steps to accomplish the task. In this blog, we unlock some of the mouse and keyboard combo tricks that can ease your routing excel tasks.

ExcelUnlocked – Mouse Double Clicks Tricks in Excel

In this special ExcelUnlocked blog, let us learn to play some excel tricks with mouse double clicks. At the end of this blog, I am sure that you would save a lot of your efforts in performing excel tasks by simply using the mouse double clicks.

How to Lookup on Picture in Excel

In one of our previous blog, we had unlocked the technique to insert and lock the picture into cells in Excel. So, let us move one step further. In this blog, we would learn to create a dynamic image or picture lookup such that we can lookup on the picture in excel based on the value in the cell without using any VBA code. With this, as the cell value changes, the picture placed in the adjacent cell changes.

Insert or Lock Image or Picture In Cell in Excel

Excel is generally said to be used for making complex calculations with formula and other functions. However, many times you may need to insert an image and picture in excel worksheet to give a visual representation of what is written in the excel. In this blog, we would learn how to insert an image or picture in an Excel cell. We would also unlock the technique to lock an image or picture into an excel cell such that when we resize or filter the cells containing the image, the picture automatically gets resized or filtered along with that cell.

How to Insert Picture or Image in Excel Comment

In this blog, we would unlock the technique to insert a picture or image in the excel comment box.

Printing Comments in Excel – Quick Guide

Printing in Excel is one of the tasks that an excel user often performs. However, whenever you print any excel worksheet, the comments in the cells does not print along with it. Reason – By default, the printing comments feature in excel is disabled in Excel. You need to enable a setting for this in order to print comments in Excel.

How to Print All or Multiple Worksheets in Excel

When you are working with a large workbook having multiple worksheets in it, one concern that comes in mind is about printing all or selected worksheets in Excel. In this blog, we would unlock the technique to print multiple worksheets (maybe all worksheets or some selected worksheets) at one go in Excel. We would also learn how to print a specific area or range of cells in all/selected worksheets in Excel.

Let's Unlock the Power of Excel

Tips and Tricks