Excel 2007 Pivot Table navigation without mouse

J

Jim

Anyone have any experience navigating Excel 2007 pivot tables through
keyboard shortcuts or voice recognition?

Possible?
Options?

Thanks
 
T

Tim

Hold the "Alt" key down and the keyboard shortcut key will appear above the
icons at the top of the Excel page. i.e. "Alt + Letter" so Alt J T I D -
will take you to the Change Data Source option on Excel.
(p.s. this used to be called up with a simple right click of the mouse in an
older version of Excel - so I'm not sure why the Microsoft gurus made it
"more" difficult to call up features on Excel - but I digress).
 
J

Jim

Thanks Tim. I was more interested in navigating the dimension
selection area than creating a connection.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Hide empty rows in pivot table Excel 2003 2
Building pivot tables in Excel 2007 based on existing pivot tables? 4
pivot table source data expand to new entries when refresh? 4
Pivot table wizards 2
Export Pivot table 1
Excel 2007 pivot table source table 1
how do I get a top 25 on a pivot table in excel 2007 1

Top