How To Freeze Rows In Excel

Just assume you are school teacher and have around 90 students in a class which is divided into various sections. Now, you have to collate their marks in every subject in an excel.If you are using a 15-inch laptop to do this, then as soon as you go to the 25th row or later you lose the context of which column is for which subject. All of this … [Read more...]

VBA Replace Function – How to Use in Excel

VBA Replace is a quite useful string function in Excel VBA. Functions like replace ease your tasks while dealing with strings.As the name suggests the job of the Replace function is to substitute a set of characters in a string with a new set of characters.In Excel VBA there are two functions that can be used for performing string replace … [Read more...]

How to Use Excel Sparklines

Excel Sparklines were introduced in Excel 2010 version. It is small line chart that could be easily embedded with the text and gives a great presentable output for easier depiction when aligned next to the tabular data. They are supported in Excel 2010 and above version only. Although sparkline’s design is not limited to lines they can also be … [Read more...]

Getting Familiar with VB Editor (VBE) : VBA Basics 002

Now, after having learned what Excel VBA is, let’s move a bit further and see what is VB Editor.VB Editor (or more commonly known as VBE) is the tool used to create, modify and maintain Visual Basic for Applications (VBA) procedures and modules in Excel.NOTE: Many people also refer VBE as Excel IDE, IDE stands for integrated development … [Read more...]

What is Excel VBA? : Excel VBA Basics 001

Visual Basic for Applications (VBA) in Excel, is a powerful and sophisticated built-in programming language that allows you to write your own functions or commands in an Excel spreadsheet.These custom functions or commands, can help to ease your tasks and thus by using Excel VBA you can do almost any imaginable thing in Excel.Now, before we … [Read more...]

How to Merge and Combine Cells in Excel – Explained

Merging cells in a spreadsheet means taking two or more cells and constructing a single cell out of them. Merging is generally used as a cosmetic trick to center a title over a particular section in a spreadsheet.The below image clearly shows how a merged cell looks like.In this post, we will see different ways to merge cells in Excel. But … [Read more...]

VBA IF Statement – Explained With Examples

IF is one of the most popular and frequently used statements in VBA. IF statement in VBA is sometimes also called as IF THEN ELSE Statement. The task of the IF Statement is to check if a particular condition is met or not.If you have followed my earlier posts, then you would remember that we discussed If Function in Excel. The IF Function in … [Read more...]

Selecting Multiple Checkboxes Using a Single Checkbox in Excel

A few weeks ago, a reader asked us a question that many can relate to: Is there an easy way to select multiple checkboxes using just one checkbox?Dealing with numerous checkboxes in a spreadsheet is a common challenge. Manually ticking each checkbox becomes a daunting task, prompting the need for a single checkbox capable of handling them … [Read more...]