How to convert a pivot table into a simple table ??as cut & paste is not possible. I have a pivot table in which months are not serial wise and i want to arrange them.
9 Replies
Ganeshbabu K
(Audit and Tax Advisory)
(48564 Points)
Replied 06 October 2012
select pivot table range,and apply ctrl+c
then go where u want to paste,do pastespecial,short cut key,
pastespecial,rightclisk,s,s,v+enter
Ganeshbabu K
(Audit and Tax Advisory)
(48564 Points)
Replied 06 October 2012
1)ctrl+c
2)right click,s,s,v,and enter
it is what doing pastespecials
vishakha sharma
(Article)
(59 Points)
Replied 06 October 2012
but in pivot table paste special also does not work
Ganeshbabu K
(Audit and Tax Advisory)
(48564 Points)
Replied 06 October 2012
why it wont works for u,while it works for me,
find file here,
Attached File : 831581 1067118 n s ram tds workings.xlsx downloaded: 230 times
CA S.Parameswaran
(CA)
(25 Points)
Replied 06 October 2012
You might have selected the entire pivot table... Follow the below steps and let us know if it works...
1. Exclude the Report filter or the column lable - depending upon the type of pivot table you have created.
2. Then select the balance table and copy...
3. Paste it in the requisite location.
vishakha sharma
(Article)
(59 Points)
Replied 06 October 2012
Hey guys it is not possible to drag the rows in a pivot table. i want to make the changes in the current pivot table instead of paste.
Ganeshbabu K
(Audit and Tax Advisory)
(48564 Points)
Replied 06 October 2012
DO SORT AFTER PASTESPECIAL,
Recent Topics
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
- Rectification Applications for Past GST Demands
- Where can I find a trusted provider to hire a skip
- GST Invoices Series
- FILING OF ITR AY 20-21
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
Related Threads
CAclubindia
