q****p 发帖数: 4536 | 1 maybe a stupid question, but asked several people, no answer. i have too
many columns, so need to paste it vertically into word.
thanks in advance! | c**t 发帖数: 2744 | 2 tranform in Excel first
【在 q****p 的大作中提到】 : maybe a stupid question, but asked several people, no answer. i have too : many columns, so need to paste it vertically into word. : thanks in advance!
| q****p 发帖数: 4536 | 3 Thanks. I used paste special and check the Transpose box in excel. It did
not work in my way because my intention is not converting the rows into
columns or columns into rows in excel.
What I want is still the original table (say 5 rows and 10 columns), but in
a vertical display in word (still 5 rows and 10 cloumns). In other words you
have to flip over the table using 90 degree to the right.
【在 c**t 的大作中提到】 : tranform in Excel first
| q****p 发帖数: 4536 | 4 OK, figure it out. kind of complicated
In word,
Insert/Break/Section Break Types/continuous break
Enter, to leave some space for pasting the table, then do it again:
Insert/Break/Section Break Types/continuous break
Then from Excel copy the table, then back to word, put the cursor in the
blank space you just left,
File/page set up/margin-orientation-landscape
Then paste as special as Worksheet.
【在 q****p 的大作中提到】 : maybe a stupid question, but asked several people, no answer. i have too : many columns, so need to paste it vertically into word. : thanks in advance!
|
|