You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...

Microsoft Excel is one of those programs that can be daunting to navigate on your first try. If you aren't particularly numbers-oriented or math-savvy, working with the different equations can be ...

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two ...

If you want to apply color in alternate rows and columns in an Excel spreadsheet, here is what you need to do. It is possible to display the desired color in every other row or column using ...

If you use Microsoft Excel, you probably know the popular spreadsheet tool automatically numbers each row in a spreadsheet outside the columns of the sheet itself. But often you want to have a column ...

How to display multiple grand total rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables do a great job of turning data into ...

With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or chronologically. You can sort all the rows in a ...

How to return a column of n consecutive values in Microsoft Excel Your email has been sent The fill handle in Microsoft Excel accommodates most serial list ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple function lets you remove a specified number of rows or columns from the start ...

Microsoft Excel's UNIQUE function does exactly as its name suggests—it extracts unique values from an array. In other words, ...