Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse. In this article, we are going to discuss the use of excel function keys (F1 to F12). Function keys provide the same output in all versions of Excel making it easier to recall.Before we head onto our topic, let us first know about … [Read more...]

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

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

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

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

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

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