Pivots can be created and maintained completely without the mouse or sighted assistance. 1) complete the Pivot assistant with the region marked you want to have in the pivot, don't forget to mark the column header also 2) placed in the new created sheet make sure you are in cell A3 3) hit F6 to go to the pivot dialog. You are placed in the field list (the names from the column headers) 4) select a field and tab to choose where to place it on the pivot area 5) tab again to the add button and hit space or enter 6) hit F6 again to return to the pivot area and see what you've got now 7) repeat steps above to make your pivot the way you want it
When you are in the pivot area on the different pivot cells, remember the context menu to modify field settings. Hth, Ralf Ralf Kefferpuetz Germany MSN/Live: [email protected] Aim: RalfKatEMC Skype/Yahoo: rkefferpuetz7747 -----Original Message----- From: Steve Jacobson [mailto:[email protected]] Sent: Wednesday, November 11, 2009 3:24 PM To: [email protected] Subject: Re: Pivot table? I remember seeing your first note, but I think that most of us have probably run into problems using the pivot table wizzard. I have attempted it on several occasions and found that I had to use the mouse keys and the results were not at all consistent. That is probably why you are not getting answers on this. As I recall, you can look at the defining parameters of a pivot table after it has been created, so the best short term solution might be to have someone set it up visually. There might be a way to create one manually without using the wizzard and there might also be a scripting approach. If you could describe what you are wanting to do with the pivot table, we might be able to suggest alternatives. Best regards, Steve Jacobson On Wed, 11 Nov 2009 14:39:02 +0100, Marek Durila wrote: >Hi all, >I didn't saw it in my in-box folder, in this Case I'm sending again. >Do you have somebody any experiences with Pivot Table in Excel? >How it's works, how can I go trough it? >It used for a statistic or listing some necessary information, but it's >everything, what I know about. >Excel 2003 or XP is optional. >I'm having classic table with 250 rows and 20 columns and I need some >columns make as rows, some as a columns and some put in data field. I'm >able go only trough vizard but what to do after? >With best regards, > Marek Durila >IBM Global Services Delivery Center Czech Republic, s.r.o., SA-dlo: >Brno, >TechnickA- 2995/21, PSC 61600 >IC: 26244535, ZapsanA- v obchodnA-m rejstrA-ku, vedenAcm KrajskA+m >soudem v Brne oddA-l C, vlo_ka 39922 IBM Global Services Delivery >Center Czech Republic, s.r.o., Registered >address: Brno, Technicka 2995/21, Zip code: 61600 Company ID: 26244535, >Entered in the Commercial Register maintained by the Regional Court in >Brno (Part C, Entry 39922) If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. All GW-Info messages are archived at http://www.gwmicro.com/gwinfo, and can be searched through and sorted using the search form at the bottom of the page. If you wish to unsubscribe from this list, send a message to [email protected] and include leave gw-info in the body of the message. If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. All GW-Info messages are archived at http://www.gwmicro.com/gwinfo, and can be searched through and sorted using the search form at the bottom of the page. If you wish to unsubscribe from this list, send a message to [email protected] and include leave gw-info in the body of the message.
