WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Converting an Excel Spreadsheet

for

From: Devarshi Pant
Date: Jul 18, 2014 8:00AM

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 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
>
> -----Original Message-----
> From: <EMAIL REMOVED> [mailto:
> <EMAIL REMOVED> ] On Behalf Of Devarshi Pant
> Sent: Friday, July 18, 2014 9:06 AM
> To: WebAIM Discussion List
> Subject: Re: [WebAIM] Converting an Excel Spreadsheet
>
> 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.
> > > > > > > >
> > > > > > >