Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column using ...
Let’s say you have student information in a worksheet where students’ last names, first names, and ID numbers are in Column A. If you want their first name and last name to appear in Column B, you ...
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 ...
How-To Geek on MSN
Excel's UNIQUE function can't skip columns—unless you use this trick
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results