Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text ...

It's easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the "Sort" feature. You can also alphabetize in Excel using shortcuts found in the "Data" or "Home" tabs.

If you prefer using Excel keyboard shortcuts ... Click the four minus signs to collapse each quarterly subgroup, leaving just the total columns visible. Then, click the plus signs to expand ...

First, I’ll show you how to find some keyboard shortcuts for one-column sorts. Then, we’ll look at a macro that runs a two-column sort. SEE: 60 Excel tips every user should master I’m using ...