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...]

History of Microsoft Excel 1978 – 2013 [Infographic]

How long have you been using Microsoft Excel?Have you ever thought how Excel or the other electronic spreadsheet softwares came to existence?In today’s post, we will go back in time to trace the origin of Excel. So, here we go:While the origin of electronic spreadsheets can be traced back to 1978, but it wasn’t until 1982 when Microsoft … [Read more...]

4 Easy Ways to Delete Blank Rows in Excel

Blank rows or blank cells in data sheets can be very annoying. Although deliberate inserting of empty rows can sometimes make your reports easier to read and understand.But if you are planning to import your spreadsheet to some other application (such as Microsoft Access) then these pesky blank rows make your life painful.And in this … [Read more...]

FileSystemObject in VBA – Explained

FileSystemObject also called FSO, provides an easy object-based model to access a computer’s file system. You simply have to create an instance of FileSystemObject in VBA and then you can generate files, read files, delete files, iterate through folders, and do many other operations on your computer’s file system.The FileSystemObject is present … [Read more...]

How to Alphabetize in Excel – The Complete Guide

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...]