[AccessD] OT: Excel Question

Hale, Jim Jim.Hale at FleetPride.com
Tue Jun 15 09:31:24 CDT 2004


If I understand your question correctly you can still get 2k to highlight
similar rows or columns. If you hover the cursor over the column or row
heading it turns into a  down arrow  (columns) or right pointing arrow
(rows). When you click it will hightlight all associated columns or rows.
For ex I have sales for the months of Jan-Apr and Gross Margin for the same
months as columns in a pivot table. If I highlight the first Jan and click
all Jan data for sales and margin are highlighted. HTH
Jim Hale

-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com]
Sent: Monday, June 14, 2004 3:35 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] OT: Excel Question


Hello All,

I apologize for the OT...but I didn't know who else to ask.  In Excel97...in

a pivot table...when you click on a cell in the table it highlights all rows

with that same value...for example...if you had 3 unit numbers...and 4 case 
types...and built the Pivot to count all case types for each unit...then on 
the pivot click on 1 case type...all rows for that case type in the pivot 
would be highlighted.

In Excel2K...this doesn't happen...only the cell you click on is 
selected...is this a setting somewhere...or is this just a functionality 
that was lost in the upgrade?

Thanks,

Mark

_________________________________________________________________
Getting married? Find great tips, tools and the latest trends at MSN Life 
Events. http://lifeevents.msn.com/category.aspx?cid=married

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list