Excel Tricks with Tejraj

In this blog post we will learn to about COLUMNS function in excel. COLUMNS function will return number of columns from selected cell range. Where to find COLUMNS function on Excel Screen: COLUMNS function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. COLUMNS function is highlighted in blue in below image. Once we click on COLUMNS option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of COLUMNS Function: The Syntax of COLUMNS function is as below: =COLUMNS(array) Arguments of COLUMNS Function: COLUMNS function takes only one argument. array : In this argument, we have to provide range of cells from which we want to find out number of columns. If we do not provide any reference here, then excel will au...

In this blog post we will learn to about ROWS function in excel. ROWS function will return number of rows from selected cell range. Where to find ROWS function on Excel Screen: ROWS function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. ROWS function is highlighted in blue in below image. Once we click on ROWS option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of ROWS Function: The Syntax of ROWS function is as below: =ROWS(array) Arguments of ROWS Function: ROWS function takes only one argument. array : In this argument, we have to provide range of cells from which we want to find out numbers of rows. If we do not provide any reference here, then excel will automatically provide the number of a ce...

In this blog post we will learn to about COLUMN function in excel. COLUMN function will return column number of a selected cell. Where to find COLUMN function on Excel Screen: COLUMN function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. COLUMN function is highlighted in blue in below image. Once we click on COLUMN option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of COLUMN Function: The Syntax of COLUMN function is as below: =COLUMN() Arguments of COLUMN Function: COLUMN function takes only one argument. reference : In this argument, we have to provide cell reference of a cell for which we want to find out COLUMN number. If we do not provide any reference here, then excel will automatically provi...

In this blog post we will learn to about ROW function in excel. ROW function will return a row number of a selected cell. Where to find ROW function on Excel Screen: ROW function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. ROW function is highlighted in blue in below image. Once we click on ROW option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of ROW Function: The Syntax of ROW function is as below: =ROW() Arguments of ROW Function: ROW function takes only one argument. reference : In this argument, we have to provide cell reference of a cell for which we want to find our row number. If we do not provide any reference here, then excel will automatically provide the row number of a cell where we ...