Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying & Pasting from Pivot Table
When I copy rows from a pivot table and paste into another worksheet of
numbers, which is NOT a pivot table, I can't sort all together (existing number in worksheet together with numbers from pivot table). I have tried formatting all to 'number' but that doesn't work. The only thing I've found that works is to click in the cell of each number pasted from the pivot table and hit the delete key at the beginning. There's no space there, there's nothing there. But hitting the delete key seems to "free" the cell in order to sort with the rest. This, however, is VERY time-consuming. Can anyone tell me a faster method? Thank you Connie Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |