Pivot Tables are undoubtedly 1 of the very best attributes of Microsoft Excel, sharing them nevertheless can turn out to be fairly difficult as soon as your file size becomes bigger so it really is not usually feasible to send the file with out either zipping it, sending by way of a transfer plan.
You might not need to constantly share your supply information as perhaps confidential. To share the summary information you will require to somehow unlink your Pivot from its information supply. Sadly Excel does not have an unlink function, but it really is attainable to attain the exact same outcome with a couple of much more more actions.
So, if you have a Pivot that you have formatted and are pleased with each presentation and level of evaluation, we can use the quite versatile Paste Unique command along with the Worth command.
a single. Firstly choose the pivot table cells and hit CTRL+C to copy the variety or you can use the Ribbon command by choosing any cell in your Table and then
- On the Pivot Table Tab- choice Features
- In the Measures group - Click Choose
- Pick the Complete Pivot
If this selection is not offered you will need to have to turn on the Allow Choice Solution.
- Pick a cell in the Table
- On the Pivot Table Tab- choice Functions
- In the Methods group -Click Pick
- Verify if Allow is ON or Off guarantee it really is ON
two. When the table is chosen then show the Paste Particular dialog box. Pressing Alt+ES is a shortcut, and it operates for all versions of Excel
three. In the Paste Specific dialog box, pick the Values solution, and click OK.
The pivot table is now unlinked, but if you use Excel 2007 or Excel 2010, the fancy pivot table style formatting is gone and we have to have to obtain this back- which we can with 2 far more more measures.
four. Show the Workplace Clipboard. In Excel 2007 and 2010, click the dialog box launcher icon in the bottom appropriate corner of the Property - Clipboard group
five. With the unlinked pivot chosen, click the item on the Workplace Clipboard that corresponds to the pivot table copy operation. It will be the final item, unless you copied anything else once the final action you performed.
Now the pivot table is unlinked from its information supply, but retains all of its original formatting. You can now very simply share the summary information that has the appear and really feel of the original information with none of the connected troubles with information sources and file size.
BJ Johnston has been an sophisticated Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com a internet site that shares Excel guidelines and tricks with it really is enthusiastic members. To join in the discussion, exactly where customers are functioning smarter and more quickly with Excel sign up for the Cost-free newsletter and as a bonus get a No cost EBook- 50 Prime Strategies and Tricks.
No comments:
Post a Comment