E-mail List Archives

Search E-mail List Archives for

Number of posts in this thread: 4 (In chronological order)

From: Clark, Michelle - NRCS, Washington, DC
Date: Fri, Jul 18 2014 6:07AM
Subject: Converting an Excel Spreadsheet
No previous message | Next message →

All,

I am exploring putting a link on a webpage to an Excel Spreadsheet. However, the spreadsheet has the information as Row Headers . Can anyone assist me with locating directions on how I can convert the information of the spreadsheet so the information is presented as Column Headers as many are accustomed? I am thinking this can be done from something I used to do many years ago. Can this be done?


Thank You,


Michelle Clark
Section 508 Coordinator
Office of the Chief Information Officer
USDA / Natural Resources Conservation Service
1400 Independence Ave. SW.
Rm. 1669-S
Washington, DC. 20250

O: 202 2609014
E-mail: = EMAIL ADDRESS REMOVED = <mailto: = EMAIL ADDRESS REMOVED = >
To learn more about Section 508, go to www.section508.gov<;http://www.section508.gov>;.

"Because your own strength is unequal to the task do not assume it is beyond the powers of man; but if anything is in the powers and province of man, believe it is within your own compass also!"

Marcus Aurelius Antoninus






This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

From: Devarshi Pant
Date: Fri, Jul 18 2014 7:06AM
Subject: Re: Converting an Excel Spreadsheet
← Previous message | Next message →

If I understood correctly, here are the steps to flip or transpose row
headers to column headers:

1. Select the block of cells to transpose with your mouse. Right-click the
mouse and click on "Copy."
2. Locate an empty portion of your spreadsheet to hold the data and
headings from the cells you copied. Click the mouse in the cell where you
want to place the copied cells.
3. Right-click your mouse. Click on the "Paste Special" menu option.
4. Click to place a check mark in the "Transpose" box of the "Paste
Special" dialog. Click the "OK" button.
5. Delete the original cells if necessary.

-devarshi
On Jul 18, 2014 8:09 AM, "Clark, Michelle - NRCS, Washington, DC" <
= EMAIL ADDRESS REMOVED = > wrote:

> All,
>
> I am exploring putting a link on a webpage to an Excel Spreadsheet.
> However, the spreadsheet has the information as Row Headers . Can anyone
> assist me with locating directions on how I can convert the information of
> the spreadsheet so the information is presented as Column Headers as many
> are accustomed? I am thinking this can be done from something I used to do
> many years ago. Can this be done?
>
>
> Thank You,
>
>
> Michelle Clark
> Section 508 Coordinator
> Office of the Chief Information Officer
> USDA / Natural Resources Conservation Service
> 1400 Independence Ave. SW.
> Rm. 1669-S
> Washington, DC. 20250
>
> O: 202 2609014
> E-mail: = EMAIL ADDRESS REMOVED = <mailto: = EMAIL ADDRESS REMOVED = >
> To learn more about Section 508, go to www.section508.gov<;
> http://www.section508.gov>;.
>
> "Because your own strength is unequal to the task do not assume it is
> beyond the powers of man; but if anything is in the powers and province of
> man, believe it is within your own compass also!"
>
> Marcus Aurelius Antoninus
>
>
>
>
>
>
> This electronic message contains information generated by the USDA solely
> for the intended recipients. Any unauthorized interception of this message
> or the use or disclosure of the information it contains may violate the law
> and subject the violator to civil or criminal penalties. If you believe you
> have received this message in error, please notify the sender and delete
> the email immediately.
> > > >

From: Clark, Michelle - NRCS, Washington, DC
Date: Fri, Jul 18 2014 7:44AM
Subject: Re: Converting an Excel Spreadsheet
← Previous message | Next message →

Thanks. I will try this. However, I am a JAWS user and believe I know what to do using the keyboard commands to do this. I appreciate your help.

Michelle

From: Devarshi Pant
Date: Fri, Jul 18 2014 8:00AM
Subject: Re: Converting an Excel Spreadsheet
← Previous message | No next message

Just in case: Control C to copy and Shift F 10 (right click) to get to the
'paste special' function.
On Jul 18, 2014 9:47 AM, "Clark, Michelle - NRCS, Washington, DC" <
= EMAIL ADDRESS REMOVED = > wrote:

> Thanks. I will try this. However, I am a JAWS user and believe I know what
> to do using the keyboard commands to do this. I appreciate your help.
>
> Michelle
>
>