ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   paste special values (https://www.excelbanter.com/excel-worksheet-functions/81363-paste-special-values.html)

baiju101

paste special values
 
Hi guys,
I hope someone can help me. If you want to copy values, i know thetrick is
to use paste special, values..However, for some reason when you type paste
specia, sometimes you do not get the option for values etc, and you get this
distinct screen with wierd looking options such as bitmap etc..

I don't know why this is and is really frustrating. I would be v grateful if
someone could help,

Thanks a lot, a frustated data entry accountant trainee,

baiju

Dave Peterson

paste special values
 
You have two different instances of excel open.

If you close one instance, then use file|Open in the first instance to open the
second file, you'll be able to see the "normal" paste special dialog.

baiju101 wrote:

Hi guys,
I hope someone can help me. If you want to copy values, i know thetrick is
to use paste special, values..However, for some reason when you type paste
specia, sometimes you do not get the option for values etc, and you get this
distinct screen with wierd looking options such as bitmap etc..

I don't know why this is and is really frustrating. I would be v grateful if
someone could help,

Thanks a lot, a frustated data entry accountant trainee,

baiju


--

Dave Peterson


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com