Excel EXPAND Function – How To Use

The EXPAND function in Excel 365 is used to dynamically expand or extend the size of a given array, depending on the provided number of rows and columns. By adding rows and columns, the EXPAND function can be used to create bigger arrays and expand them as per our requirements.The EXPAND function also allows us to pad the extended array with the … [Read more...]

Excel DROP Function – How To Use

The DROP function removes the specified number of rows or columns from the start or end of the array. The function is highly useful for removing headers, outliers, or any unnecessary data.The DROP function accepts the number of rows or columns to exclude and returns a new array or dataset. Understand the function and make full use of it while … [Read more...]

Excel ROW Function – How To Use

The ROW function retrieves the row numbers of a given cell, range of cells, or array. It is a versatile function and is useful in Conditional Formatting and when dealing with large datasets. The ROW function can also be combined with other Excel functions to create solutions as per our needs.It is worth noting that the ROW function returns the … [Read more...]

Excel ROWS Function – How To Use

The ROWS function counts the total number of rows in a given cell range or an array. The function is highly helpful when dealing with large datasets and enables better data analysis.The ROWS function also includes blank rows when calculating the total number of rows.SyntaxThe syntax of the ROWS function is as follows.=ROWS(array)The ROWS … [Read more...]

How to Make Positive Numbers Show Up in Green in Excel

What is the easiest way to analyze information? Yes, it is visual but how can you make numeric or textual data visual? Right again, you color-code it! So, our best bet for making positive numbers stand out from negative ones is to color-code them. And the immediate color code for +ive and -ive we comprehend is green and red.This tutorial is about … [Read more...]

Watch Window in Excel – Keep Track of Important Cells

Assume a target where you need to track the changes in the value of a particular cell. The cell of interest is hundreds of rows below (N300 and N500 for example). We want to see the effect of changing E50 and G50 on N300 and N500. Or we could want to keep an eye on their formulas. Do we keep scrolling back and forth?Or what if we want to compare … [Read more...]

Excel COLUMNS Function – How To Use

The COLUMNS function in Excel allows us to determine the total number of columns in a given cell range or array. It is a simple and straightforward function that is incredibly useful when dealing with large amounts of data.The COLUMNS function can also be used to set up data validations and, when combined with other Excel functions, result in … [Read more...]

How to Change Tab Color in Excel (3 Easy Ways + Shortcut)

Dear readers, "tab" here refers to a worksheet tab in Excel that is used to select a worksheet and among other options, is used to rename, group, and hide a sheet and even color the tab itself. With Excel set to the regular "Colorful" theme, the following is how worksheet tabs will appear in a file:The active worksheet has a white tab while the … [Read more...]