AutoCollect - Creating User Defined DELTA Rowsets › Create a Sample Empty Excel Sheet › Transposing an Excel Spreadsheet
Transposing an Excel Spreadsheet
As we mentioned in the second sample for the DSVOUT function, sometimes there is a need to rotate an Excel spreadsheet from a horizontal (landscape) to vertical (portrait) format. This can be accomplished using the copy and paste functions of Excel.
For MS-Excel 2003
- Highlight all of the active columns in the current spreadsheet.
- Issue a copy command to copy the cells into memory.
- Highlight a new worksheet or a new area on the existing spreadsheet.
- Choose PASTE SPECIAL.
- From the PASTE SPECIAL menu, choose the TRANSPOSE option.
- Press Enter.
The resulting pasted area will be transposed (rotated) as requested.
For MS-Excel 2007
- Highlight all of the active columns in the current spreadsheet.
- Issue a copy command to copy the cells into memory.
- Highlight a new worksheet or a new area on the existing spreadsheet.
- Click on the PASTE drop-down button
- From the PASTE menu, choose the TRANSPOSE option.
- Press Enter.
The resulting pasted area will be transposed (rotated) as requested.
Copyright © 2014 CA.
All rights reserved.
|
|