Selecting All Checkboxes using a Single Checkbox in Excel

A few weeks ago, one of my readers left a comment on my blog asking if there is a way to select a bunch of checkboxes using a single checkbox. [Link to that comment]This is not a new issue, when you have a huge form with many checkboxes, it becomes quite cumbersome to select each checkbox individually. And this gives rise to the need of a … [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...]

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

Hiding Gridlines in Excel

Hiding gridlines in Excel is a common task and most of the 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 gridbars represent the borders of these … [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 about 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 into and to avoid unnecessary increase in 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...]

Concatenate in Excel – Explained

Often the data in your spreadsheets is not according to your needs, so you may need to replace some strings, split some text or concatenate strings to format the data as per your needs.  String concatenation is the process of joining two or more strings together. Excel gives you the capability of concatenating a series of … [Read more...]

How to Unhide Columns in Excel

While doing data analysis in excel you would have noticed that all the data is not important for the end user (can be your boss).  Some of the columns are used merely for calculation purpose and that’s why it’s better to hide these columns as they create un-necessary confusions.But now when it comes to unhide these columns, there are … [Read more...]

Privacy Policy | Disclaimer | About