In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods are still valid in Excel 2013, but the combined data ...

The first reason why you might see double square brackets in a structured reference is that the column headers they refer to contain a special character. In these cases, the extra pair of square ...

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use those ...

Using just one formula, you can create an entire table, generate a filtered view, calculate a running total, or build a ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...

The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel Your email has been sent Most Microsoft Excel functions are autonomous—one result value for each function or formula.

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data. To create a validation list with ...

How to unhide row 1 and column A in an Excel sheet Your email has been sent The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and ...