Contextures -- Excel TipsInstructions and sample files for Excel techniques, including data validation, pivot tables, and filters.Increase Numbers by a Set Amount with Paste Special- May 19, 2008 Use Paste Special to increase all the numbers in a range by a set amount. For example, raise prices by $1.50 or by 5%, all at once.http://www.contextures.com/xlDataEntry04.html Show Grand Totals at the Top of a Pivot Table- May 15, 2008 There's no setting that allows you to display the grand total at the top of a pivot table. However, with this technique you can use another field that acts as the grand total, and display it at the top.http://www.contextures.com/xlPivot13.html Assign Players Each Inning- May 12, 2008 Select a player from a dropdown list, and that name disappears from the other dropdowns for that inning.http://www.contextures.com/excelfiles.html |