Excel PivotTable Autofilter on data value

When working with pivot table,
you may find the Autofilter feature for data value is disabled from Pivot table.

2010

2003

To take the autofilter for data value, first, select the cell near the header like below image.

After that, go to Data Ribbon(2007/2010)/Menu(2003/XP)->filter again,

you would see that the Autofilter feature is back

2010

2003 

However, beware that the Total value are not affected by the autofilter function.

2010

2003

If showing total value for filter data required, it could be achieved by setting up some helper formulas and then add it to page filter.

For Programmers
If your existing application are accessing the old preview box.
you can still access the old preview mode. It's also not inside the 2010 object model change list:

ActiveWindow.SelectedSheets.PrintPreview 

Formula Recipe:Random order list

To transform a given list of item in random order, the following formula could be used:
RAND - for creating random number
ROW - used with RAND to generate random number
LARGE - To match out the list from ranking.
VLOOKUP - used with LARGE for locate exact position of item

Assume the list of Target is located in column B


Step1: add formula in A2:
=INT(RAND()*1000)+ROW()/10000
the "ROW()/10000" is used to prevent duplicated random number.Even the rand() result is 0, the default ranking would be row number. The 10000 is the possible number of items in the list.

Step 2: add formula in D2:
=LARGE(A$2:A$21,ROW()-1)

To generate sorted list of rank
Step 3: add formula in E2
=VLOOKUP(D2,A$1:B$21,2,FALSE)
Based on the sorted list of rank, look for the sorted list of targets.

Step 4: extend the formula in A2,D2 and E2 to number items by copy and paste

Finish!

Excel 2010: Print Preview Full Screen (Old Print Preview)

For Users

From menu controls, the new print preview mode has completely replaced the old print preview.
The new print preview mode offer a streamlined "quick printing" in one screen:
Selecting printer, number of copies, paper orientation,... All in One

However, convenience control "margin manual tuning" (as below) is missing from the new mode.

Actually, the old print preview is still not removed.
You can add it to the quick access bar, or any ribbon (new ribbon customization feature in Office 2010)

The below steps demonstrate how to release the old print preview (Print Preview Full Screen) method to the quick access bar

Step 1:Click on the more 

Step 2:

Finish, Click this button to launch the old print preview screen:

---

For Programmers

If your existing application are accessing the old preview box.

you can still access the old preview mode. It's also not inside the 2010 object model change list:

ActiveWindow.SelectedSheets.PrintPreview