Can Excel show the column headers on every screen? How to freeze panes and split screens How to freeze and unfreeze columns and rows in Excel.

How to Center Horizontally & Vertically in Excel. When crafting an Excel 2010 spreadsheet for your business, getting the look just right is important, making data easier to browse and understand.

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.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions.