WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Converting an Excel Spreadsheet

for

From: Devarshi Pant
Date: Jul 18, 2014 7:06AM

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 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 REMOVED> <mailto: <EMAIL 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.
> > > >