Paste Special Values

  • Thread starter Thread starter gwc
  • Start date Start date
G

gwc

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?
 
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
 
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







- Show quoted text -
Click to expand...





THANK YOU!!!!!!
 
Back
Top