Using the transpose option, you can return a horizontal range of cells as a vertical range, or vice versa.

Question:    Can I return a horizontal range of cells as a vertical range, or vice versa?

Answer:        Yes, using the transpose option

 Why:           To change the positional alignment of the data

Applies To:  MS Excel 2003, 2007, 2010

1. For this example we shall make use of the screen shot given below

2.  Select cells A1:O1

3.  Press Ctrl + C

4.  Select cell D4

5.   Select as below

6.         Select Transpose then OK

7.         Select cells A1:O1 then press the delete key

8.         The result will be as follows

Initially the data in row 1 was aligned horizontally but has been changed to vertical alignment and placed in column D by using the transpose option

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations

Further Reading:

1. Printing a Range of Pages
2. LARGE Function
3. Subtotal Visible Cells
4. Small Function
5. Fill Blank Cells