Paste Special Values


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

Advertisements

G

Gord Dibben

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
 
Ad

Advertisements

G

gwc

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 -





THANK YOU!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top