Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special Values
After I use DATA/SUBTOTALs, columns, I click the outline level 2
symbol (at the left of the spreadsheet) to see only the totals and the grand total. I then choose a range of cells, click "Go To Special", click "Visible Cells Only" and click COPY. On a different spreadsheet, when I click "PASTE SPECIAL", instead of a box with: All Formulas Values Formats etc. the box lists: Microsoft Office Excel Worksheet Object Picture (Enhanced Metafile) Bitmap etc. How do I PASTE SPECIAL VALUES? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special Values
Your target workbook and the source workbook are open in two separate
instances of the Excel Application. Close one and open both books in the single instance. Gorc On Sun, 29 Jan 2012 19:36:07 -0800 (PST), gwc wrote: After I use DATA/SUBTOTALs, columns, I click the outline level 2 symbol (at the left of the spreadsheet) to see only the totals and the grand total. I then choose a range of cells, click "Go To Special", click "Visible Cells Only" and click COPY. On a different spreadsheet, when I click "PASTE SPECIAL", instead of a box with: All Formulas Values Formats etc. the box lists: Microsoft Office Excel Worksheet Object Picture (Enhanced Metafile) Bitmap etc. How do I PASTE SPECIAL VALUES? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special Values
On Jan 29, 8:37*pm, Gord Dibben wrote:
Your target workbook and the source workbook are open in two separate instances of the Excel Application. Close one and open both books in the single instance. Gorc On Sun, 29 Jan 2012 19:36:07 -0800 (PST), gwc wrote: After I use DATA/SUBTOTALs, columns, I click the outline level 2 symbol (at the left of the spreadsheet) to see only the totals and the grand total. I then choose a range of cells, click "Go To Special", click "Visible Cells Only" and click COPY. On a different spreadsheet, when I click "PASTE SPECIAL", instead of a box with: * * All * * Formulas * * Values * * Formats * * * *etc. the box lists: * * Microsoft Office Excel Worksheet Object * * Picture (Enhanced Metafile) * * Bitmap * * * *etc. How do I PASTE SPECIAL VALUES?- Hide quoted text - - Show quoted text - THANK YOU!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special Values VBA | Excel Programming | |||
paste special (values) | Excel Worksheet Functions | |||
Paste Special values only | Excel Worksheet Functions | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Paste special values | Excel Programming |