Search Contextures Sites
Custom Search

Excel Videos - GetPivot Data, Paste Special

Use the GetPivotData to pull values from a pivot table, or turn that feature off. Use Paste Special to increase the value in selected cells.

Generate GetPivotData

Increase Numbers by a Set Amount with Paste Special (Excel 2003)

Increase Numbers by a Set Amount with Paste Special (Excel 2007)

More Videos

Generate GetPivotData

If you are trying to link to a pivot table cell, you might have problems. For example, when you type an equal sign, then click on a cell in a pivot table, you may see a GETPIVOTDATA formula, instead of a cell reference. In this pivot table tutorial video, you'll see how to work around that problem, and learn how to prevent the problem from occurring.

You'll add the Generate GetPivotData button to a toolbar, to turn this feature off. By customizing the toolbar, you can turn the feature on again, if you need it, or leave the Generate GetPivotData feature turned off.

For written instructions for this Excel tutorial, see: Generate GetPivotData

Increase Numbers by a Set Amount with Paste Special (Excel 2003)

In Excel 2003, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by $1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel menu bar. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

Increase Numbers by a Set Amount with Paste Special (Excel 2007)

In Excel 2007, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by $1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel Ribbon. The technique is similar to the steps in the previous video, for Excel 2003, but the command is in a different location. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

More Videos

Excel Videos - Index

Data Entry Tips

Pivot Tables

Mouse Shortcuts

Pivot Table Tips

Pivot Table Groups and Filters

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 31, 2016 7:41 PM