| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Column to Header
I have a word documents once saved in excel it has the Header/Titles
(A1:down) on the first column. The information for that header is to the right of it. How would I go about changing that so that when I'm using mail merge it displays as the header (A1:across). Example A B C 1 | FName | John | Michael 2 | LName | Smith | Williams 3 | Address | 4th Street | 8th Ave -- Work is sometimes hard....but someone has to do it. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Column to Header
Maybe you are looking for Transposing.
Select range Copy Select upper left cell of a destination range PasteSpecial/check Transpose check button Regards, Stefi €˛Pierre€¯ ezt Ć*rta: I have a word documents once saved in excel it has the Header/Titles (A1:down) on the first column. The information for that header is to the right of it. How would I go about changing that so that when I'm using mail merge it displays as the header (A1:across). Example A B C 1 | FName | John | Michael 2 | LName | Smith | Williams 3 | Address | 4th Street | 8th Ave -- Work is sometimes hard....but someone has to do it. |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Column to Header
that is what I was looking for - ty very much
-- Work is sometimes hard....but someone has to do it. "Stefi" wrote: Maybe you are looking for Transposing. Select range Copy Select upper left cell of a destination range PasteSpecial/check Transpose check button Regards, Stefi €˛Pierre€¯ ezt Ć*rta: I have a word documents once saved in excel it has the Header/Titles (A1:down) on the first column. The information for that header is to the right of it. How would I go about changing that so that when I'm using mail merge it displays as the header (A1:across). Example A B C 1 | FName | John | Michael 2 | LName | Smith | Williams 3 | Address | 4th Street | 8th Ave -- Work is sometimes hard....but someone has to do it. |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Column to Header
You are welcome! Thanks for the feedback!
Stefi €˛Pierre€¯ ezt Ć*rta: that is what I was looking for - ty very much -- Work is sometimes hard....but someone has to do it. "Stefi" wrote: Maybe you are looking for Transposing. Select range Copy Select upper left cell of a destination range PasteSpecial/check Transpose check button Regards, Stefi €˛Pierre€¯ ezt Ć*rta: I have a word documents once saved in excel it has the Header/Titles (A1:down) on the first column. The information for that header is to the right of it. How would I go about changing that so that when I'm using mail merge it displays as the header (A1:across). Example A B C 1 | FName | John | Michael 2 | LName | Smith | Williams 3 | Address | 4th Street | 8th Ave -- Work is sometimes hard....but someone has to do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
| Autofill column header to the last column | Excel Worksheet Functions | |||
| Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
| Column and Row header | Setting up and Configuration of Excel | |||
Linear Mode
