Calculating Weighted Average in Excel

The concept of an average comes from mathematics, average can be defined as the result obtained by adding several quantities together and then dividing this total by the number of quantities.Usually, when we calculate average, we put the same weight or priority to each value, this is called an un-weighted average.For example, let’s say 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...]

Printing Comments in Excel – Few Easy Ways

An Excel workbook with comments looks more presentable and easier to understand. But do you know that, by default Excel only allows you to see comments on the screen. In other words, it has made the option of printing comments very inconspicuous.Now, what if you have to print those comments along with your data?No need to worry. In this post, I … [Read more...]

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

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