19 Everyday Use Excel VBA Codes

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 😎

Read more19 Everyday Use Excel VBA Codes

“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.

Read more“Arrow Keys Not Working in Excel” – Solved

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.

Read moreHow to Lookup on Picture in Excel

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.

Read moreInsert or Lock Image or Picture In Cell 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.

Read moreHow to Print All or Multiple Worksheets in Excel