In other words, you want to take a column of consecutive numbers or words, say, from 1 to 5 or Able, Baker, Charlie, and flip the order—running from 5 to 1 or alphabetizing the words in reverse order.

Dynamic arrays allow Excel formulas to adjust automatically when new data is added. This means that as you input new information, the formulas update without any manual effort.

How to Rotate a Worksheet in MS Excel 2003. Excel documents come in the form of spreadsheets, also known as worksheets, made up of a collection of cells on a single sheet of data.