[gui-talk] Pivot tables in Excel

[Ted Shelly]

Thanks.  F6 is the magic key.  I was then able to tab and arrow through the
options and get what I needed.

Ted

-----Original Message-----
From: gui-talk [mailto:gui-talk-bounces at nfbnet.org] On Behalf Of Steve
Jacobson
Sent: Saturday, February 15, 2014 9:54 PM
To: Discussion of the Graphical User Interface, GUI Talk Mailing List
Subject: Re: [gui-talk] Pivot tables in Excel

If you are using Excel 2007 or greater, go to the sheet where you have
specified the pivot table to be created, and then press F6 and you will get
into the fields list.  You can then use the Applications key to access menus
that let you manipulate these fields.  I am new at this myself so am still
learning, but I believe you have to have Excel 2007 or later to use this.
I'm not sure it was there in Excel 2003.

Best regards,

Steve Jacobson

On Sat, 15 Feb 2014 14:12:20 -0800, Ted Shelly wrote:

>Hi all,

> 

>Does anyone know of a way to create pivot tables in Excel with just 
>keyboard commands?  I tried researching this on Google but could not find
an answer.
>In case you don't know what a pivot table is, it is a way to summarize 
>rows of data.  I want to use it to total up various categories of 
>tax-deductable items that I have listed in a spreadsheet.  I am using 
>Excel 2013, but probably earlier versions work similarly.

> 

>Thanks,

> 

>Ted Shelly

>_______________________________________________
>gui-talk mailing list
>gui-talk at nfbnet.org
>http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
>To unsubscribe, change your list options or get your account info for
gui-talk:
>http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/steve.jacobson%40
>visi.com





_______________________________________________
gui-talk mailing list
gui-talk at nfbnet.org
http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
To unsubscribe, change your list options or get your account info for
gui-talk:
http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/tshelly2000%40gmail.co
m