This article explains about creating and using drop down list in excel using data validation. Why in survey’s we will see options are limited (majority of the cases) where in the user can choose his/ her option from the available list of options. The answer is simple and well known. An organized/ properly formatted data …
Drop Down List in Excel – How to create and use using Data Validation Continue Reading »
Excel is not a typing program as it is majorly used to work with numbers and analyzing data. However all your efforts go in vain if there are typos or spelling mistakes in the representation of data. This comes as a challenge for many users to identify and correct the spelling mistakes or typos in …
In this article let us understand about the Excel COLUMN Function. The Formula Syntax of Column Function in Excel. What is Excel Column Function The purpose of Excel Column function is to know or get the column number for a given cell or range. This function returns the column number(s) depending on the input. Note …
In this article let us understand about the Excel Row Function. The Formula Syntax of Row Function in Excel. What is Excel Row Function The purpose of Excel Row function is to know or get the row number for a given cell or range. This function returns the row number(s) depending on the input. Note …
Do you mouse while using excel. Do you know that in few scenarios using mouse is better than using keyboard. Surprised !!!. Let us see the different situations/ scenarios where mouse works better than keyboard. Learn the double click tricks in excel Many Excel Users will be eager to learn keyboard shortcuts to work fast …
Must know Excel Double Click Tricks – Work Faster with Excel Continue Reading »
The other day I had a conversation with one of my friends who uses excel regularly. We are discussing on some random things in excel. The discussion went around customization of default options in excel. He is bored of looking at the same color options in excel which are set by default specially with the …
How to Change Color of Gridlines in Excel – Fun Tip Continue Reading »
We know that every cell in the spreadsheet has a unique name by default. This name is nothing but the combination of the row number and the name of the column. Now the question is can I have my own name(s) assigned to a cell/ a group of cells (range) instead of the default name …
How to Create and Use Named Ranges in Excel Continue Reading »
