Most people know how to alphabetize a list in excel, but few of them actually know the best and fastest ways to do it. In this tutorial, I am going to highlight some of the best methods to alphabetize in Excel.What does alphabetizing a column means and what are its usesAlphabetizing a column or list means sorting a list alphabetically in excel. … [Read more...]
VBA InputBox – How to Use
In an earlier post, we have talked about MsgBox which is exactly opposite to VBA InputBox. The job of the InputBox function in VBA is to get some input from the user. It displays a dialog to the user that gives him a cue of which value should be entered, then it returns this value to the program.Syntax of InputBox in VBAIts syntax is as … [Read more...]
Hiding Gridlines in Excel
Hiding gridlines in Excel is a common task and most Excel users should know about it. It makes your spreadsheet clean and presentable. Although grid lines in excel have their own benefits but in some cases, it is better to hide them.What are Gridlines?A spreadsheet contains cells and gridlines or grid bars represent the borders of these cells. … [Read more...]
VBA Select Case Statement – Explained
In our previous posts, we have talked about Excel If Statement and Excel Nested If’s, and in today’s post we will discuss VBA select case statement. VBA Select Case can be used instead of complex Excel Nested If statements. This makes the VBA code faster to execute and easier to understand.Select-Case statement (also called as Switch Case in … [Read more...]
Excel Relative and Absolute References – Explained
In our last post about Finding duplicates in Excel, we created a clever formula to find only single instance of a duplicate value using the concept of Excel absolute references. In that post, we were unable to discuss further Absolute and Relative references, but today we will understand what these references mean.Excel Relative … [Read more...]
Find and Delete Duplicates in Excel – The Ultimate Guide
While working with huge data tables in Excel there are times when your data may contain duplicate records.To eliminate the confusions that duplicate records may result in and to avoid an unnecessary increase in the physical size of the spreadsheet it is better to find and remove the duplicate records.Today I will be sharing five easy and … [Read more...]
VBA InStr and InStrRev – How to Use
As the name suggests VBA InStr function looks for a substring embedded inside another string and then returns its starting position. If it cannot find the string inside the parent string then it returns 0. It is a very important function among the string functions in VBA. It is probably the best function to perform string search … [Read more...]
Excel Nested If’s – Explained
In our last post, we talked about the IF Statement, which is one of the most important functions in Excel. The limitation of the IF statement is that it has only two outcomes. But if you are dealing with multiple conditions then Excel Nested If’s can come in very handy.Nested if’s are the formulas that are formed by multiple if statements one … [Read more...]
