MCS

Unlike other Microsoft programs such as Word, Excel does not have a button to automatically number data. However, you can easily number your data by using the fill handle to fill a series.

Transposing Data allows you to re-arrange rows into columns or vice versa- basically interchanging the two.

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page.