+ Reply to Thread
Results 1 to 2 of 2

Paste Special Values-when I paste into the last book

  1. #1
    Registered User
    Join Date
    01-15-2009
    Location
    Anchorage, Alaska
    MS-Off Ver
    Excel 2003
    Posts
    1

    Paste Special Values-when I paste into the last book

    I am trying to paste a group of cells from one excel book that gets information from two other books. For the past...forever...when I paste into the last book, I right click the cell and paste special and got several options to choose from, the paste with values is the one I am after.

    Now, for a reason I am sure is my fault, when I paste special, I get two options;

    Paste:
    Paste link:

    I don't want those options. I want the option list that gives me the option of pasting special with values. Anyone have an idea of what I could have done wrong to make the values option screen go away.

    Thank you

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Try View > Toolbars > Customize, on the Commands tab click Rearrange, select Menu Bar in the next dialog, and click Reset.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1