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) is True. It Continue Reading
VBA / Excel Tutorials
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 OR, NOT, Continue Reading
Having a dropdown list can be particularly useful if an Excel sheet is created by one and used by others. In that case, you may limit the Continue Reading
You may require show or hide the formula for different situations. For example, by default Excel does not show the formula in the cell where you applied Continue Reading
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 Continue Reading
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 Continue Reading
While working in Excel, you will require adding one or more rows in between the existing rows that contain text or other information. In this tutorial, I Continue Reading
After hiding the column(s), row(s) or sheet (as explained in the hide columns/rows tutorial), if you want to unhide those; this is also simple and the topic Continue Reading
In this tutorial, you will learn how to add a column in between other existing columns. For example, you have entered values in columns A, B, C, Continue Reading
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 Continue Reading
Your worksheet may contain lots of data and sometimes it's only painful if you require to find/go through only a few rows out of hundreds. Thanks to Continue Reading
In simple terms, moving the rows and columns in Excel is just the matter of cut and paste or pressing the short keys Ctrl + X and Continue Reading
In Excel, freezing the first column (the leftmost) is pretty easy. Similarly, freezing two or more columns is easy but a little trick that I will show Continue Reading
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 Continue Reading
In this tutorial, you will learn how to password protect a cell, multiple cells, a row and multiple rows in MS Excel. So that, the worksheet that Continue Reading