Q: I read your colleague David Einstein's description of how to make row and column headings repeat on each page of an Excel spreadsheet in Windows. The Mac version appears to be just a bit ...

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.

Click OK to copy the contents of the column. Now, you can sort the copied list by clicking any cell in it and choosing Sort from the Data menu. By default, Excel selects the Header Row option.

How do I automatically sort Excel by color? All you have to do is click on the AutoFilter arrow located next to the column heading you want to sort, then choose Sort by Color via the dropdown menu.

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions We start with the basics for navigating, entering, and calculating data.