VBA / Excel Tutorials

Just like the AND function, the OR is a logical function in Excel. The OR function returns True if any of the given condition(s) are True. It only returns False if all the given conditions evaluate as False.

The AND is a logical function in Excel that determines if all the conditions in a test are TRUE. The other logical function examples are

In this tutorial, I will show you how to create a dropdown list in Excel that only shows values that you set along with an example of allowing users selecting a value from the available dropdown list plus writing their own.

In this tutorial, you will learn how to show or hide the formula in the cells and formula bar in Excel.

If you have long text to enter in an Excel cell or just require pushing text to next lines for clarity or for any other reasons, you may add a new line easily. In this tutorial, I will show you…

In certain cases, the cells in a worksheet contain text that is bigger than the default width. For example, you have a description cell for a product sheet or remarks/feedback in a customer sheet. In that case, the cell’s width/height…

In this tutorial, I will show you how to add one or multiple rows in Excel. With demos, you can also see the shortcut for adding rows.

In the first section, I will show you with screen shots, how to unhide the column(s) in Excel. This is followed by the section to unhide rows and finally, you can see how to unhide a sheet.

In this tutorial, you will learn how to add a column in between other existing columns.Two ways of adding the column in for that scenario are explained below.

Hiding the rows or columns in Excel is just the matter of right clicking on the column letter or row number and pressing the Hide option in the menu.

Thanks to Excel built-in functionality, you may filter data and return only desired rows or columns by certain criteria.

In simple terms, moving the rows and columns in Excel is just the matter of copy and paste or pressing the short keys Ctrl + X and Ctrl + P, that you might already used too while working in Excel, MS Word or other programs.

In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.

If you suddenly start seeing navigating from cell to cell is stopped while pressing the arrow keys and rather navigating in the worksheet then your scroll lock is ON.

In this tutorial, you will learn how to password protect a cell, multiple cells, a row and multiple rows in MS Excel.