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

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

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 few … [Read more...]

Count Number of Times a Character Appears in Cell

Yesterday I got an email from one of my readers saying that he wanted to count the number of instances of a character inside a cell.To give you a better understanding of the question let me explain the question in detail.For instance: The A1 cell of your excel sheet contains a text string like “All work and no play makes Jack a dull boy” now … [Read more...]

How to Find Cells containing Formulas in Excel

A few days back I had a huge spreadsheet in which I had to find out the cells containing formulas. Initially, I was totally clueless about how this task can be done.But later after doing some Google searches, I got a few ideas on how I can effortlessly identify the formula cells in excel.And today to share my experiences with you guys, In … [Read more...]