A:
1 Answer
rank
1
|
That option still exists, but you need to add the 'PivotTable and PivotChart Wizard' command to the Quick Access toolbar (Found in 'Commands not in the Ribbon'), and use that command to start a new pivot table. Q: I can't find the command to apply names to cell references in a formula. In Excel 2003, the command was Insert / Name / Apply. A: The Define Name control in the Formulas / Defined Names groups is a drop-down. Click the down-arrow, and you'll see the Apply Names command.
more
|
spreadsheetpage.com
Related Videos
Add your answer...
Top Answerers
1.
2.
3.
Top Askers
1.
2.
3.
Top Supporters
1.
2.
3.
What happened to the ability to create a pivot table using the Multiple Consolidation Ranges option?
Related Questions
- Gillette Fusion features a new forward pivot. The restoring force of the cartridge has been improved, ...
- All The Pivot bath screens can be open inwards and outwards. The hinged bath screens only can be open ...
- You can't display text data in the data area of a PivotTable. You could display the text fields in the Row ...
- There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the ...
- If you remove data from the PivotTable source data, that information might still appear in the PivotTable ...