banner_ad

Please reply fast

619 views 9 replies

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.

Replies (9)

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

not working..

1)ctrl+c 

2)right click,s,s,v,and enter

 

it is what doing pastespecials

but in pivot table paste special also does not work

why it wont works for u,while it works for me,

find file here,

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.

 

 

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.

DO SORT AFTER PASTESPECIAL,

thanks..smiley


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details