If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#2
|
|||
|
|||
Hi Connie-
Have you tried using EditPaste Special - Values ? HTH |:) "Connie Martin" wrote: 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 |
#3
|
|||
|
|||
I hadn't tried that, and just did now, but it still won't sort until I press
the Delete key before each number. Connie Martin "CyberTaz" wrote: Hi Connie- Have you tried using EditPaste Special - Values ? HTH |:) "Connie Martin" wrote: 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 |
#4
|
|||
|
|||
What I meant to say in my first response to you is that the numbers still
won't sort unless I perform a delete at the beginning of each number, which in essence, is pressing the backspace key. Once I do that the numbers will sort in with the existing numbers in the spreadsheet. I have even tried the format painter. Still doesn't work. Connie Martin "CyberTaz" wrote: Hi Connie- Have you tried using EditPaste Special - Values ? HTH |:) "Connie Martin" wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Pivot Table option, display as data list, repeating items down | carl.fields | Worksheet Functions | 4 | September 17th, 2004 07:57 PM |
Problem copying pivot table | LJones | General Discussion | 1 | July 30th, 2004 03:07 PM |