Learn how to split one column into multiple columns in Excel. Use Text to Columns and Delimited options and use Delimiters to separate data in Excel.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

Unhide All Rows and Columns in Excel If you have multiple hidden columns or rows in your spreadsheet, you might want to unhide them all at once.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.