| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
preparing pivot fields for copying and paste special for sorting
I have discovered that many Excel functions do not work in a pivot table and
I have to copy and paste special to another worksheet to perform certain sorts. If I have primary and secondary rows like State1 City1 City2 State2 City1 City2 Is there any way to force the state to show up on each line with the cites so records can be kept together in a sort?? Thanks -- rsmith333 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
preparing pivot fields for copying and paste special for sorting
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html rsmith333 wrote: I have discovered that many Excel functions do not work in a pivot table and I have to copy and paste special to another worksheet to perform certain sorts. If I have primary and secondary rows like State1 City1 City2 State2 City1 City2 Is there any way to force the state to show up on each line with the cites so records can be kept together in a sort?? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
preparing pivot fields for copying and paste special for sorting
Thanks!!!!
-- rsmith333 "rsmith333" wrote: I have discovered that many Excel functions do not work in a pivot table and I have to copy and paste special to another worksheet to perform certain sorts. If I have primary and secondary rows like State1 City1 City2 State2 City1 City2 Is there any way to force the state to show up on each line with the cites so records can be kept together in a sort?? Thanks -- rsmith333 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
| "paste special" "paste link" | Excel Discussion (Misc queries) | |||
Linear Mode
