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 function returns both columns as a spill array, automatically sizing to fit the data. This is why CHOOSECOLS is one of the Excel functions that can save significant time. It eliminates the need ...

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.

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

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 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 ...

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and ...

When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below. How to ...

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...