Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Insert Header Vertically?
- Thread starter blopez
- Start date
- Thread starter
- #2
OK, this is the long way around, and I have Excel 2000, but it is the only way that I know of to get the result you want. (there may be an easier way that I just don't know)
You can flip your data and thus your header and footers will be vertical. Cut the data in the spreadsheet, and click in a cell toward the bottom of your spreadsheet and click Edit, Paste special, transpose. This will paste your spredsheet vertically. Then highlight the data and go into Format, Cells and change the alignment to 90 degrees, this is so the data will be vertical as well. Hope this helps. Dawn
You can flip your data and thus your header and footers will be vertical. Cut the data in the spreadsheet, and click in a cell toward the bottom of your spreadsheet and click Edit, Paste special, transpose. This will paste your spredsheet vertically. Then highlight the data and go into Format, Cells and change the alignment to 90 degrees, this is so the data will be vertical as well. Hope this helps. Dawn
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question