Transpose Function in Excel – How to Use

The term transpose literally means swapping rows and columns. And similarly transpose function in excel flips rows into columns and vice-versa. Transpose is an array function i.e. it can only be applied on a range of cells. And today in this post I will be guiding you on how to use transpose functionality in excel. What are Array Functions and why … [Read more...]

How to Insert Multiple Rows in Excel

In last few decades Microsoft has grown by leaps and bounds and so are its fabulous products. Microsoft Excel is one of such products that has grown immensely. It has wonderful features and options to make your tasks easier. But one feature that it lacks is the ability to insert multiple rows. The default insert option that the Excel has allows you … [Read more...]

Excel Indirect Function – How to Use

Excel Indirect Function is one of the most useful functions in Microsoft Excel. Indirect function takes a cell reference in the form of a string, then it evaluates the reference and shows its content. This gives you a better way to deal with variable cell references. Excel Indirect Function Syntax: The syntax of indirect function is quite … [Read more...]

Find Merged Cells in Excel

There are times when you try to sort a column in your spreadsheet and it throws an error saying that, “To do this, all merged cells should be of same size”. As you can clearly see that this issue is due to the presence of merged cells in the column to be sorted.   To resolve this issue you simply need to find the Merged Cells present in … [Read more...]

Excel SUMPRODUCT Function – How To Use

On hearing the name of Excel SUMPRODUCT Function for the first time, it looks like some useless formula that can do some predefined sum and product operations. But actually it’s far from that definition. In fact it is a very useful function if you need to analyse the data of two or multiple arrays in excel. How Excel Defines SUMPRODUCT … [Read more...]

How to Find External Links or References in Excel

Manually finding external links or references in a spreadsheet is a cumbersome task.  Microsoft does not have any inbuilt function that can find external references or links but still there do exist some workarounds to do this. And this is what I am going to share with you today. Method 1: Finding external References by using the find … [Read more...]

How to Hide Formulas in Excel

Using formulas in excel can make your day to day tasks easier. Excel provides formulas for just about anything. But if you are sharing your spreadsheets with other people then it looks quite rude to write formulas as it is.   All the formulas and the calculation stuff should be hidden from the viewers. The best way to do this is to hide … [Read more...]

Online Excel Viewers – Few Tools to View Excel Files Online

In our day to day life we are too heavily dependent on Excel files. We create our reports, graphical charts, monthly budgets using it. But one thing that continuously annoys me is, that these excel spreadsheets can only be opened or viewed using few third party tools (like MS Office or Open Office). Windows doesn't have any stock application that … [Read more...]

Privacy Policy | Disclaimer | About